J
Judy L
In my spreadsheet I have the following formula to sum values but it won't
work when I try to use a wildcard.
=SumProduct(($B$49:$BJ$55="FA-*)*IsNumber($F$49:$BN$55),$F$49:$BN$55)
The formula works if I use one of the actual categories (ie: FA-1)
But I have several FA-1 through FA-10 and FA-PH.
Any help would be greatly appreciated,
Thank you
work when I try to use a wildcard.
=SumProduct(($B$49:$BJ$55="FA-*)*IsNumber($F$49:$BN$55),$F$49:$BN$55)
The formula works if I use one of the actual categories (ie: FA-1)
But I have several FA-1 through FA-10 and FA-PH.
Any help would be greatly appreciated,
Thank you