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