|Mar 12, 2010, 03:52 PM||#1|
Numbers Help - sum column based on value in other column
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?
8500 - Yikes! - "Windtunnel" - mini(Early 2009)
Wallstreet - iBook(DualUSB) - MBP CoreDuo - MBP Core2Duo 2.66GHz 15"
|Mar 13, 2010, 09:01 AM||#2|
What you want is the SUMIF command.
=SUMIF([range of labels],[label to test],[range of miles])
The spreadsheet below used this formula:
What looks large from a distance, close up ain't never that big.
|Thread Tools||Search this Thread|
|thread||Thread Starter||Forum||Replies||Last Post|
|Help - MP4 file OK on 1 Mac but not other||orionsbell||Digital Video||2||Jan 7, 2011 06:08 AM|
|Numbers formula needed please!||AndoverV||Mac Basics and Help||1||Nov 9, 2010 08:20 PM|
|Numbers Help - Numbers That Begin With Zero (000001, etc)||panda bear||Mac Applications and Mac App Store||2||Apr 5, 2010 02:31 PM|
|Numbers Help - Refresher Course||Prof.||Mac Applications and Mac App Store||0||Jul 16, 2008 04:35 PM|
All times are GMT -5. The time now is 07:16 AM.