Numbers Help - sum column based on value in other column

[network23]

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!

 

[mysterytramp]

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

 

[network23]

Perfect! Thank you!