wild cards in SUMIF
 

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

wild cards in SUMIF
 

Wildcards in formulas can only be used on TEXT.

Try this:

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

Biff

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

wild cards in SUMIF
 

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:D)

Biff

"Biff" wrote in message
...
Wildcards in formulas can only be used on TEXT.

Try this:

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

Biff

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