wild cards in SUMIF

[Charles]

Wild cards do not work in SUMIF. =SUMIF(J:J,"10/*/2006",D) gives me zero
while =SUMIF(J:J,"10/13/2006",D) gives me a correct sum.

 

[Biff]

Wildcards in formulas can only be used on TEXT.

Try this:

=SUMPRODUCT(--(TEXT(J1:J100,"mmyyyy")="102006"),D1100)

Biff

 

[Biff]

P.S.

You can't use entire columns as references in Sumproduct (** unless you're
using Excel 2007 Beta).

This won't work **:

=SUMPRODUCT(--(TEXT(J:J,"mmyyyy")="102006"),D)

Biff