IF/THEN statements in numbers

Discussion in 'Mac Apps and Mac App Store' started by BrandonIrby, Jan 6, 2013.

  1. macrumors newbie

    Joined:
    Jan 6, 2013
    #1
    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
     
  2. macrumors 6502

    prisstratton

    Joined:
    Dec 20, 2011
    Location:
    Winnipeg
    #2

Share This Page