Go Back   MacRumors Forums > Apple Applications > Mac Applications and Mac App Store

Reply
 
Thread Tools Search this Thread Display Modes
Old Mar 12, 2010, 03:52 PM   #1
network23
macrumors 6502
 
Join Date: Dec 2002
Location: Wisconson
Send a message via ICQ to network23 Send a message via Yahoo to network23
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?

Thanks!
__________________
8500 - Yikes! - "Windtunnel" - mini(Early 2009)
Wallstreet - iBook(DualUSB) - MBP CoreDuo - MBP Core2Duo 2.66GHz 15"
network23 is offline   0 Reply With Quote
Old Mar 13, 2010, 09:01 AM   #2
mysterytramp
macrumors 65816
 
mysterytramp's Avatar
 
Join Date: Jul 2008
Location: Maryland
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 Thumbnails
Click image for larger version

Name:	Screen shot 2010-03-13 at 8.58.26 AM.png
Views:	78
Size:	24.6 KB
ID:	218043  
__________________
What looks large from a distance, close up ain't never that big.
mysterytramp is offline   0 Reply With Quote
Old Mar 15, 2010, 08:06 PM   #3
network23
Thread Starter
macrumors 6502
 
Join Date: Dec 2002
Location: Wisconson
Send a message via ICQ to network23 Send a message via Yahoo to network23
Perfect! Thank you!
__________________
8500 - Yikes! - "Windtunnel" - mini(Early 2009)
Wallstreet - iBook(DualUSB) - MBP CoreDuo - MBP Core2Duo 2.66GHz 15"
network23 is offline   0 Reply With Quote

Reply
MacRumors Forums > Apple Applications > Mac Applications and Mac App Store

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Similar Threads
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 12:26 PM
Finder Column Bbafett OS X Mavericks (10.9) 1 Oct 24, 2013 11:34 AM
Finder column view modify width of active column foxs Mac Programming 6 Jul 24, 2013 08:14 AM
How do I remove "Bookmark" column & only have "Address" column in a bookmarks folder? oolala iMac 0 Jul 12, 2013 11:40 PM
How to: Split one column into two LouiseT OS X 10.8 Mountain Lion 3 Apr 11, 2013 01:13 PM

Forum Jump

All times are GMT -5. The time now is 05:29 PM.

Mac Rumors | Mac | iPhone | iPhone Game Reviews | iPhone Apps

Mobile Version | Fixed | Fluid | Fluid HD
Copyright 2002-2013, MacRumors.com, LLC