Numbers Help - sum column based on value in other column

Discussion in 'Mac Apps and Mac App Store' started by network23, Mar 12, 2010.

  1. macrumors 6502

    Joined:
    Dec 18, 2002
    Location:
    Wisconson
    #1
    I'm sure this is easy to answer by someone with basic spreadsheet skills, which I lack...

    I have a column of numbers (miles) and a column of use (Personal, Medical, Business).

    How do I set up 3 formulas so that I get the sum of the mileage column for each of the Personal, Medical, and Business categories?

    Thanks!
     
  2. macrumors 65816

    mysterytramp

    Joined:
    Jul 17, 2008
    Location:
    Maryland
    #2
    What you want is the SUMIF command.

    =SUMIF([range of labels],[label to test],[range of miles])

    The spreadsheet below used this formula:

    =SUMIF(C2:C6,"Medical",B2:B6)

    mt
     

    Attached Files:

  3. thread starter macrumors 6502

    Joined:
    Dec 18, 2002
    Location:
    Wisconson

Share This Page