=SUMPRODUCT((J1:J300)*(--(MONTH(A1:A300)=1))) for January

=SUMPRODUCT((J1:J300)*(--(MONTH(A1:A300)=2))) for February

etc.

--
Gary''s Student - gsnu200772


"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