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