sumproduct with wildcard for text?
Hi,
Sumproduct doesn't accept wildcards, try this
=SUMPRODUCT(($B$1:$BJ$5="high")*(LEFT($F$1:$BN$5,1 1)="requirement"))
Mike
"nattie" wrote:
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 : )
|