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