| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sumif wildcard criteria | Excel Worksheet Functions | |||
| Wildcard with sumif | Excel Discussion (Misc queries) | |||
| Nesting SUMIF with Wildcard | Excel Worksheet Functions | |||
| Sumif using wildcard | Excel Worksheet Functions | |||
| SUMIF, wildcard and cell ref | Excel Worksheet Functions | |||
Hybrid Mode
