View Single Post
  #1   Report Post  
ber_harris
 
Posts: n/a
Default 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