» 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:
- Windows XP All-in-One Desk Reference For Dummies
- Financial Statement Analysis: A Practitioner's Guide, 3rd Edition
- Quantitative Methods in Derivatives Pricing: An Introduction to Computational Finance
- The Financial Numbers Game: Detecting Creative Accounting Practices
- Guide to Financial Reporting and Analysis
- Real Estate Loopholes: Secrets of Successful Real Estate Investing
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