Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Sumproduct with "contains" variable
When you filter a column in Excel 2007, there is an option of "contains" to
choose. Is it possible to use "contains" in a sumproduct() formulae as one of the arrays or do I have to list the possibilities in each of the variables? Surely there must be a way to use wildcard characters of ? or * or something to pass this on in the formulae. If so, how? Thanks, -- Lee Coleman |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Sumproduct with "contains" variable
=sumproduct(--(isnumber(search("sometext",a1:a10))),
--(b1:b10="somethingelse"), (c1:c10)) Lee wrote: When you filter a column in Excel 2007, there is an option of "contains" to choose. Is it possible to use "contains" in a sumproduct() formulae as one of the arrays or do I have to list the possibilities in each of the variables? Surely there must be a way to use wildcard characters of ? or * or something to pass this on in the formulae. If so, how? Thanks, -- Lee Coleman -- Dave Peterson |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Sumproduct with "contains" variable
Thank you so very much. It is too simple.
Thanks again, Lee "Dave Peterson" wrote in message ... =sumproduct(--(isnumber(search("sometext",a1:a10))), --(b1:b10="somethingelse"), (c1:c10)) Lee wrote: When you filter a column in Excel 2007, there is an option of "contains" to choose. Is it possible to use "contains" in a sumproduct() formulae as one of the arrays or do I have to list the possibilities in each of the variables? Surely there must be a way to use wildcard characters of ? or * or something to pass this on in the formulae. If so, how? Thanks, -- Lee Coleman -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
"Type mismatch" when I try to fill an Array variable with "+" | Excel Discussion (Misc queries) | |||
SUMPRODUCT(--ISNUMBER(FIND("AM",C5:160))*(k5:k160="") | Excel Discussion (Misc queries) | |||
HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel |