| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumproduct with wildcards
This formula works
=SUMPRODUCT(--(client=A$19),--(contractors=$A4),clientvalue) How do I add wildcard *A$19* & *$A4*to the equation? NB "*" & A$19 doesn't do it on it's own Saintsman |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Sumproduct with wildcards
I think that you will help an extra column with
=FIND($A$19,B4)0 for each cell and then doing sum product over the answer column. -- Hope this helps Martin Fishlock, Bangkok, Thailand Please do not forget to rate this reply. "Saintsman" wrote: This formula works =SUMPRODUCT(--(client=A$19),--(contractors=$A4),clientvalue) How do I add wildcard *A$19* & *$A4*to the equation? NB "*" & A$19 doesn't do it on it's own Saintsman |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Sumproduct with wildcards
Thanks for response
Managed to find a similar query in forum & amended that - used search function "Martin Fishlock" wrote: I think that you will help an extra column with =FIND($A$19,B4)0 for each cell and then doing sum product over the answer column. -- Hope this helps Martin Fishlock, Bangkok, Thailand Please do not forget to rate this reply. "Saintsman" wrote: This formula works =SUMPRODUCT(--(client=A$19),--(contractors=$A4),clientvalue) How do I add wildcard *A$19* & *$A4*to the equation? NB "*" & A$19 doesn't do it on it's own Saintsman |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Sumproduct with wildcards
=SUMPRODUCT(--(ISNUMBER(SEARCH(A$19,client))),--(ISNUMBER(SEARCH($A4,contractors))),clientvalue)
"Saintsman" wrote: This formula works =SUMPRODUCT(--(client=A$19),--(contractors=$A4),clientvalue) How do I add wildcard *A$19* & *$A4*to the equation? NB "*" & A$19 doesn't do it on it's own Saintsman |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sumproduct won't accept wildcards | Excel Worksheet Functions | |||
| Sumproduct and wildcards | Excel Worksheet Functions | |||
| Can wildcards be used in SUMPRODUCT conditions | Excel Worksheet Functions | |||
| Wildcards with SumProduct | Excel Worksheet Functions | |||
| adding two sumproduct formulas together | Excel Worksheet Functions | |||
Linear Mode
