» 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:
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