IF/THEN statements in numbers

[BrandonIrby]

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

[prisstratton]

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