Register FAQ / Rules Forum Spy Search Today's Posts Mark Forums Read
Go Back   MacRumors Forums > Apple Applications > Mac Applications and Mac App Store

Reply
 
Thread Tools Search this Thread Display Modes
Old Mar 12, 2010, 02: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, 08: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:	72
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, 07: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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
thread Thread Starter Forum Replies Last Post
Help - MP4 file OK on 1 Mac but not other orionsbell Digital Video 2 Jan 7, 2011 05:08 AM
Numbers formula needed please! AndoverV Mac Basics and Help 1 Nov 9, 2010 07:20 PM
Use javascript to change <td> background colour based on value in an array dom.mason Web Design and Development 2 May 5, 2010 04:49 PM
Numbers Help - Numbers That Begin With Zero (000001, etc) panda bear Mac Applications and Mac App Store 2 Apr 5, 2010 01:31 PM
Numbers Help - Refresher Course Prof. Mac Applications and Mac App Store 0 Jul 16, 2008 03:35 PM


All times are GMT -5. The time now is 06:42 AM.

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

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