Register FAQ / Rules Forum Spy Search Today's Posts Mark Forums Read
Go Back   MacRumors Forums > Apple Applications > Mac Applications and Mac App Store

Reply
 
Thread Tools Search this Thread Display Modes
Old Jan 6, 2013, 11:07 PM   #1
BrandonIrby
macrumors newbie
 
Join Date: Jan 2013
IF/THEN statements in numbers

Hello all,

I am attempting to make a template spreadsheet in numbers to automatically calculate and SUM revenues from different cities in my service area.

City in which job was in -column A
Job revenue in- column B
Total revenues by city in- row 30


Ex.

Formula in cell F:30
=IF column A contains 'city a' then SUM amount in 'column B'

I do understand this is not a valid formula, I am attempting to relay the desired effect.

Any help will be much appreciated.

Thanks,
Brandon
BrandonIrby is offline   0 Reply With Quote
Old Jan 7, 2013, 10:04 AM   #2
prisstratton
macrumors regular
 
Join Date: Dec 2011
Location: Winnipeg
I do not use Numbers, but in Excel I would use the SUMIF() function.

Check this thread and my response/example:

http://forums.macrumors.com/showthread.php?t=1493249
__________________
 17" 2011 MacBook Pro, 2.3 GHz i7 Quad, 16GB DDR3, Intel 520 240GB SSD
prisstratton is offline   0 Reply With Quote

Reply
MacRumors Forums > Apple Applications > Mac Applications and Mac App Store

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -5. The time now is 12:44 PM.

Mac Rumors | Mac | iPhone | iPhone Game Reviews | iPhone Apps

Mobile Version | Fixed | Fluid | Fluid HD
Copyright 2002-2013, MacRumors.com, LLC