» 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:
- The Intelligent Investor: The Definitive Book On Value Investing, Revised Edition
- Absolute Beginner's Guide to Microsoft Office Excel 2003
- Not-for-Profit Accounting Made Easy
- Financial Peace: Revisited
- Marketing Plans That Work, Targeting Growth and Profitability
- The Total Money Makeover. : A Proven Plan for Financial Fitness
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