Sumif or if statements-Help!
I have a spreadsheet listing employee hours per week. I want to create a
formula that will total up the total regular hours and the overtime hours
seperately. I would like the spreadsheet to total the 118 regular hours and
then the 2 overtime hours in the cell underneath. I hope this makes sense.
Thanks in advance for you assistance.
Sarah
40
38
42
Total Regular Hours 118
Total Overtime Hours 2
|