Using wildcards in criteria for sumifs functions

P

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
 
G

Gary''s Student

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

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

etc.
 
Top