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

Reply
 
Thread Tools Search this Thread Display Modes
Old Nov 20, 2012, 02:13 PM   #1
jent
macrumors 6502a
 
Join Date: Mar 2010
Sum cells depending on number in preceding cell?

I'm trying to develop an Excel spreadsheet that tallies the number of total hours worked on different projects.

My goal is to be able to enter in a single row the date, the project number, and the number of hours worked on that project. I'm just wondering if it's possible to have Excel look at the "Project number" column, and then assign the number of hours worked in the next column to a tally of total hours worked for that specific project.

I'm attaching screenshots of what I would want the spreadsheet to look like. The first screenshot would be what I manually type in after each day and project, and the second screenshot would be the automatically summed information.

Thanks!
Attached Images
  
jent is offline   0 Reply With Quote
Old Nov 20, 2012, 03:00 PM   #2
iMacFarlane
macrumors 65816
 
iMacFarlane's Avatar
 
Join Date: Apr 2012
Location: Phaselocking Psychos somewhere on Pandora
Check out the Excel documentation for the SUMIF() function. If that doesn't give you the power you want or need, you may need to learn about array functions, which get ugly fast but really pack a punch with shaping your data as you see fit.
__________________
"We make our world significant by the courage of our questions and by the depth of our answers."-Carl Sagan
iMacFarlane is offline   0 Reply With Quote
Old Nov 20, 2012, 06:56 PM   #3
prisstratton
macrumors regular
 
Join Date: Dec 2011
Location: Winnipeg
Something like this:
Attached Thumbnails
Click image for larger version

Name:	SNAG-0014.jpg
Views:	44
Size:	38.1 KB
ID:	378683  
__________________
 17" 2011 MacBook Pro, 2.3 GHz i7 Quad, 16GB DDR3, Intel 520 240GB SSD
 11" 2012 MacBook Air, 1.7 GHz i5 Duo, 4GB, 128GB
 4th. Gen. iPad, 16GB, WiFi  4th. Gen. TC, 2GB
prisstratton is offline   1 Reply With Quote
Old Nov 27, 2012, 11:08 PM   #4
jent
Thread Starter
macrumors 6502a
 
Join Date: Mar 2010
The SUMIF() function works great. Thank you!
jent is offline   0 Reply With Quote

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

Tags
conditional, excel, formula, functions, office

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Similar Threads
thread Thread Starter Forum Replies Last Post
Can your iPhone be hacked with only using your cell phone number? determined09 iPhone 21 Jul 17, 2014 12:32 AM
Separating a cell and home number ringtone AK10R iOS 7 3 Dec 26, 2013 10:32 AM
How do I get a collection view cell's column number? moonman239 iPhone/iPad Programming 2 Dec 20, 2013 02:35 AM
Excel cells that attribute a score if two cells are the same ellisfella Mac Applications and Mac App Store 0 Nov 21, 2013 06:48 AM
Possibility of 2 cell phones using same number? jimbo1mcm iPhone 4 Feb 11, 2013 04:26 PM

Forum Jump

All times are GMT -5. The time now is 01:18 PM.

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

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