=SUMPRODUCT(--(MONTH(A1:A100)=2),--(YEAR(A1:A100)=2008),J1:J100)


"PaulJK" wrote:

Hi

I have a range of dates in Column A in the format of dd/mm/yyyy

When I try to use the following function the result is just zero

=SUMIFS(J:J,A:A,"??/01/2008")

I am trying to add all entries in J for each month

Can anybody please help?

Thanks

Paul