Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sumproduct with wildcard for text?
I have the following formula that it won't work when I try to use a wildcard.
=SumProduct(($B$1:$BJ$5="high")*($F$1:$BN$5="requi rement*")) The formula works if I use one of the actual categories (ie: requirement) But I have several "requirement" type such as "requirement is waiting", "requirment done". Any help would be greatly appreciated, Thank you so very muchhh : ) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Wildcard and Sumproduct | Excel Worksheet Functions | |||
SUMPRODUCT WITH WILDCARD | Excel Discussion (Misc queries) | |||
wildcard in sumproduct? | Excel Worksheet Functions | |||
Sumproduct Wildcard | Excel Discussion (Misc queries) | |||
Sumproduct with Wildcard * | Excel Worksheet Functions |