sumif wildcard criteria

C

craig

I cant seem to get the wild card to work in a simple SUMIF
My criteria data is as follows
579910001
569410001
538610001
.......Etc

The criteria I want use is 10001

I have tried
=SUMIF(Plan!$A1:$A1000,"5*10001",Plan!C1:C1000)
=SUMIF(Plan!$A1:$A1000,"5***10001",Plan!C1:C1000)
=SUMIF(Plan!$A1:$A1000,"5???10001",Plan!C1:C1000)
and other variations....

Is there something simple I am not seeing.
Best Rgd Craig
 
T

T. Valko

Apparently you can't see my earlier reply (the ngs had some problems
earlier).

Wildcards won't work on numeric values.

Try this...

=SUMPRODUCT(--(RIGHT(Plan!$A1:$A1000,5)="10001"),Plan!C1:C1000)
 

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

Top