» Summing the Number of Hours an Employee Worked During a Two Week Period
CATEGORY - Summing
VERSION - All Microsoft Excel Versions
Columns A & B contain the number of hours worked by each ID this week.
Columns D & E contain the equivalent information for last week.
We want a total of the hours worked by a specified ID over the entire period.
Solution:
Use the SUMIF function as shown as shown in the following formula:
=SUMIF(A3:A7,B10,B3:B7)+SUMIF(D3:D7,B10,E3:E7)
Book Store:
Recommended Books:
- Monte Carlo Methods in Finance
- Marketing Plans That Work, Targeting Growth and Profitability
- Business Plans Kit for Dummies (With CD-ROM)
- Microsoft Windows XP Inside Out
- Advanced modelling in finance using Excel and VBA
- The Intelligent Investor: The Definitive Book On Value Investing, Revised Edition
Why is B10 in the calculation?
Tom
Your screen shot showes the calculations for the first week in A3:A6 and I assume be B3:B6
=SUMIF(A3:A7,B10,B3:B7) Why are you going down to the next cell. What does B10 represent?
SCREENSHOT
DLE
HOW IS THIS EXAMPLE SUPPOSE TO HELP ME?...WHERES THE REST OF THE SHOT?
that would be good.
Regards,
Jesse