use sumif to calculate totals

[robertvdb]

I've known how to do this in the past, but I can't find it back.

I have a table of values for each employee, during a given period (Oct-Nov-Dec). I need the sum for each employee during each of these months. That sum would appear in H5, using SUMIF or anything alike.

See image.

 

[RoryA]

You want SUMIFS:

=SUMIFS(D:D,A:A,H3,C:C,H4)

 

[robertvdb]

Thanks Rory ! I knew it was not too complicated !