Formula Gurus needed

[cmccambridge]

Hi

I need a formula to calculate total hours by adding G114 to G149 depending on whether the corresponding number in column H is either 1,2, or 3. (column H has a drop down list with these options)

Thanks!

[JoePublic]

Your question isn't particularly clear, to me at least - do you mean:
=IF(OR(H1={1,2,3}),G114+G149,0)
Perhaps a sample workbook could be provided?

[dond427]

How about this?

=SUMIF(I114:I149,">0", J114:J149) - SUMIF(I114:I149,">4", J114:J149)

[cmccambridge]

Start Time End Time Hours Rate 10:30 AM 3:30 PM 5 1 5:00 PM 10:00 PM 5 1 12:00 PM 8:00 PM 8 1 9:30 AM 1:00 PM 3.5 1 1:00 PM 5:00 PM 4 1 7:00 PM 9:00 PM 2 1 10:15 AM 2:00 PM 3.75 2 2:30 PM 4:30 PM 2 1 5:00 PM 10:00 PM 5 2 12:00 PM 2:30 PM 2.5 1

Hours column is G, Rate Column is H. I need to add the hours in G for all rate 1, then a different cell to add all rate 2s and so on

[JoePublic]

=SUMIF(H114:H149,1, G114:G149)
then
=SUMIF(H114:H149,2, G114:G149)
and so forth