Sum per date

[norlax]

HI GUYS! PLEASE HELP!

As per attachment, I want to sum per month using a excel formula.

for example:
1. sum if all date is equal to APRIL


THANKS IN ADVANCE

[bebo021999]

May it works:
=SUMPRODUCT((MONTH($B$2:$N$2)=4)*$C$2:$O$2)

[norlax]

Thank you Sir bebo021999. It works in the file that I attached but not in my actual excel file.

this is my formula:
=SUMPRODUCT((MONTH(CR140:DP140)=4)*CS140:DQ140)

even though the dates are not 4, it has amount.

[norlax]

this are my data:

30-Oct-13 10,000.00 21-Nov-13 8,500.00 21-Dec-13 8,500.00 21-Jan-14 8,500.00 00-Jan-00 - 00-Jan-00 - 00-Jan-00 - 00-Jan-00 - 00-Jan-00 - 00-Jan-00 - 00-Jan-00 - 00-Jan-00 -

[norlax]

if the data are place in B2, using your formula, the value is 83,289.00, but it should be zero.