Formula Gurus needed

cmccambridge

New member
Joined
Apr 4, 2013
Messages
4
Reaction score
0
Points
0
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

Super Moderator
Staff member
Joined
Sep 16, 2011
Messages
222
Reaction score
1
Points
18
Location
UK
Excel Version(s)
2016
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

New member
Joined
Jan 7, 2013
Messages
13
Reaction score
0
Points
0
How about this?

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

cmccambridge

New member
Joined
Apr 4, 2013
Messages
4
Reaction score
0
Points
0
Start TimeEnd TimeHoursRate
10:30 AM3:30 PM51
5:00 PM10:00 PM51
12:00 PM8:00 PM81
9:30 AM1:00 PM3.51
1:00 PM5:00 PM41
7:00 PM9:00 PM21
10:15 AM2:00 PM3.752
2:30 PM4:30 PM21
5:00 PM10:00 PM52
12:00 PM2:30 PM2.51


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

Super Moderator
Staff member
Joined
Sep 16, 2011
Messages
222
Reaction score
1
Points
18
Location
UK
Excel Version(s)
2016
=SUMIF(H114:H149,1, G114:G149)
then
=SUMIF(H114:H149,2, G114:G149)
and so forth
 
Top