I am putting together a timesheet - see example

Col D Col E
11 Time In 8:30 AM
12 Time Out 12:30 PM
13 Hours 4.0
14 Rate 1.5
15 Meal Break
16 Time In 1:00 PM
17 Time Out 3:00 PM
18 Hours 2.0
19 Rate 2.0
20 Total @ 1.5 0.5
21 Total @ 2.0 6.0

In E20, I wanted to calculate the number of hours worked where rate = 1.5
(similar for E21 but for rate=2.0)

I tried SUMIF, but it gave odd results (results expected should have been 4
hours @ 1.5 and 2 hours @ 2.0) using =SUMIF(E11:E19,1.5,E13) and
=SUMIF(E11:E19,2.0,E13) respectively.

A) - I cannot have more than 2 cells in the sumrange as they are not adjacent
B) - SUMIF results are dependent upon results of other formulae in the cells
C) - results not expected

Help anyone? Sorry if this is clear as mud.


Its a bit complicated but