Consolidate Monthly data

[rizmomin]

Hi:

This should be very simple for lots of excel users.
I should also know but for some reason my mind is blank.

Please refer to attached sheet.

I need a formula to add Monthly data.

Please let me know if you have any questions.

Thanks

Riz

[martindwilson]

try
=SUMPRODUCT((MONTH($B$2:$B$8)=MONTH(E2))*(YEAR($B$2:$B$8)=YEAR(E2)),$C$2:$C$8)

[rizmomin]

Hi:

Thank you so much.,..this works..

Love it...

Riz