|Jan 6, 2013, 11:07 PM||#1|
IF/THEN statements in numbers
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
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.
|Jan 7, 2013, 10:04 AM||#2|
I do not use Numbers, but in Excel I would use the SUMIF() function.
Check this thread and my response/example:
17" 2011 MacBook Pro, 2.3 GHz i7 Quad, 16GB DDR3, Intel 520 240GB SSD
|Thread Tools||Search this Thread|
All times are GMT -5. The time now is 12:44 PM.