sum cells of one column that eqaul similar text in another column

M

MichaelTM99

I'm working on the completion of a timesheet. I am trying to sum the hours
in Coulmn G (9-22), with text that may be equal to four categories (types of
Leave... ANNUAL, SICK, COMP, or OTHER in Column H) ... so... I want to sum
only ANNUAL hours with ANNUAL hours, SICK with SICK, and so on... wish I
could explain it better. If someone wants to help me out or suggest anything
I appreciate it in advance. I've tried a lot of things... and am becoming
frustrated.
 
B

Biff

Hi!

Try either of these:

=SUMIF(H9:H22,"sick",G9:G22)

=SUMPRODUCT(--(H9:H22="sick"),G9:G22)

Biff
 
Top