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?
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?
This website wants to know your momentum - | Deny | | Allow |
How about this?
=SUMIF(I114:I149,">0", J114:J149) - SUMIF(I114:I149,">4", J114:J149)
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
=SUMIF(H114:H149,1, G114:G149)
then
=SUMIF(H114:H149,2, G114:G149)
and so forth
Bookmarks