sumif wildcard criteria

  • Thread starter Thread starter craig
  • Start date Start date
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
 
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)
 
Back
Top