» 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:
- Cashflow Quadrant: Rich Dad's Guide to Financial Freedom
- How to Use Financial Statements: A Guide to Understanding the Numbers
- Windows XP for Dummies
- F1 Get the Most out of Excel! The Ultimate Excel tip Help Guide
- The Sweet Potato Queens' Big-Ass Cookbook and Financial Planner
- Now, Discover Your Strengths
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