wild cards in SUMIF

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Wildcards in formulas can only be used on TEXT.

Try this:

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

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

Biff
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

can you imbed a sumif 1
Use dynamic column reference without R1C1 3
sumifs, sumif with dates 6
SumIf Function Question 6
sumif wildcard criteria 1
Sumif Function 1
I need to write a PRODUCT formula that mimics a SUMIF 3
problem with excel logic, too complicated of a function set??? 3

Back
Top