Sum Multiple Column with Date Range Criteria

[positivemind]

Hi all,

I need help with a formula to sum two columns using date range as criteria. Please find the attached sheet to sum D and E column using date as criteria (col B). So the answer I should get in cell I5 as 36992 for Jan month and 13947.50 for Feb month in I6.
Please help. Thank you in advance!

[JohnTopley]

In I5

=SUMPRODUCT((MONTH($B$6:$B$11)=MONTH($H5))*($D$6:$E$11))

copy down

[positivemind]

thank you so much! you just made my life easy.

[wk9128]

Cell I5 formula , Drag down

Please Login or Register  to view this content.

[positivemind]

Excellent. thank you too

[wk9128]

@positivemind You're Welcome. Glad to help . Thank You for the feedback.

you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower
left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.