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
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