sumif wildcard criteria

C

craig

Hi, I cant seem to get the wildcard to work with a simple sumif
I have a range of numbers as below
597910001
587910001
567910001

I wish to sumif on the last five being 10001

I have tried
=SUMIF(Plan!$A1:$A1000,"*10001",Plan!C1:C1000)
=SUMIF(Plan!$A1:$A1000,"5???10001",Plan!C1:C1000)
and all other sorts of variations. I would have thought the wildcard would
work
Thanks Craig
 
T

T. Valko

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

Similar Threads

sumif wildcard criteria 1
Calculate average in intervals 1
SUMIF with criteria "<>" & "=" 4
sumif wildcard for text and numbers 5
muliple sheet range + sumif / sumproduct 3
Have the SUMIF result (formula) on a separate sheet/tab 2
Sumif formula 4
SUMPRODUCT, COUNTIF and wildcard 3

Top