|Nov 20, 2012, 02:13 PM||#1|
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.
|Nov 20, 2012, 03:00 PM||#2|
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
|Nov 20, 2012, 06:56 PM||#3|
Something like this:
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
|conditional, excel, formula, functions, office|
|Thread Tools||Search this Thread|
|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|
All times are GMT -5. The time now is 01:44 PM.