SUMIF-incorrect return

[ExcelNewby]

Please see attachment.

I have a formula =SUM(IF($E$3:$E$600<=H8,$D$3:$D$600,0)) and the objective is to total the monthly salaries based on the month that they were hired. I keep having amounts come up in the incorrect month.

TIA,

ExcelNewby

[rylo]

Hi

Try
J3: =SUMPRODUCT(--($E$3:$E$18=H3),($D$3:$D$18))


rylo

[ExcelNewby]

Thank you for staying late to assist us.


ExcelNewby