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

Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
Old Nov 20, 2012, 01:13 PM   #1
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.

Attached Images
jent is offline   0 Reply With Quote

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

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 16, 2014 11:32 PM
Separating a cell and home number ringtone AK10R iOS 7 3 Dec 26, 2013 09:32 AM
How do I get a collection view cell's column number? moonman239 iPhone/iPad Programming 2 Dec 20, 2013 01: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 05:48 AM
Possibility of 2 cell phones using same number? jimbo1mcm iPhone 4 Feb 11, 2013 03:26 PM

Forum Jump

All times are GMT -5. The time now is 10:34 AM.

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

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