If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
sumif wildcard criteria
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 |
#2
|
|||
|
|||
sumif wildcard criteria
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) -- Biff Microsoft Excel MVP "craig" wrote in message ... 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 |
Thread Tools | |
Display Modes | |
|
|