|Mar 12, 2010, 02: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, 08: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|
|On Numbers How make a column add the date automatic||Boxito||Mac Applications and Mac App Store||0||Dec 13, 2013 11:26 AM|
|Finder Column||Bbafett||OS X Mavericks (10.9)||1||Oct 24, 2013 10:34 AM|
|Finder column view modify width of active column||foxs||Mac Programming||6||Jul 24, 2013 07:14 AM|
|How do I remove "Bookmark" column & only have "Address" column in a bookmarks folder?||oolala||iMac||0||Jul 12, 2013 10:40 PM|
|How to: Split one column into two||LouiseT||OS X 10.8 Mountain Lion||3||Apr 11, 2013 12:13 PM|
All times are GMT -5. The time now is 09:29 PM.