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 Nov 20, 2012, 01: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, 02:00 PM   #2
iMacFarlane
macrumors 6502a
 
iMacFarlane's Avatar
 
Join Date: Apr 2012
Location: Somewhere between Markarth and Riften
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.
__________________
Knowledge is power. Learn something new every day!
iMacFarlane is offline   0 Reply With Quote
Old Nov 20, 2012, 05: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:	21
Size:	38.1 KB
ID:	378683  
__________________
 17" 2011 MacBook Pro, 2.3 GHz i7 Quad, 16GB DDR3, Intel 520 240GB SSD
prisstratton is offline   1 Reply With Quote
Old Nov 27, 2012, 10: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

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


All times are GMT -5. The time now is 12:01 AM.

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

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