Using wildcards in criteria for sumifs functions

[PaulJK]

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

 

[Gary''s Student]

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

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

etc.

 

[Teethless mama]

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