IF Column E month equals get Column D Value

[badincite]

Trying to search column E for anything in JAN and return the corresponding cells "D" value

My attempt =IF(MONTH(E1:E5)=1,(D1:D5))

[JohnTopley]

try

=IF(MONTH(E1)=1,D1,"")

and copy down E2 to E5

will set cell to blank if not JAN

[reagan.kha]

=if(month(e1)=1,d1,"")

[badincite]

Yeah that works but I need to search the whole column E1-E5 and and then return/add the corresponding values in D1-D5 if there in that month.

[JohnTopley]

=SUMPRODUCT((month(E1:E5)=1)*(D1:d5))

will sum values in D range if E range = Jan

[Sam Capricci]

can you use a helper column? If you use =month(E1) dragged down in another location, say F1 through F5, then this in another cell =SUMIF(F1:F5,1,D1:D5) that would work.

[badincite]

Winner! Thanks