Wildcard in SumProduct
 

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

Wildcard in SumProduct
 

If it always begins with FA-, try it this way:

=SumProduct((LEFT($B$49:$BJ$55,3)="FA-")*IsNumber($F$49:$BN$55),$F
$49:$BN$55)

Hope this helps.

Pete

On Apr 11, 12:42*pm, Judy L wrote:
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

Wildcard in SumProduct
 

Thank you, thank you, it works perfect!

Judy

"Pete_UK" wrote:

If it always begins with FA-, try it this way:

=SumProduct((LEFT($B$49:$BJ$55,3)="FA-")*IsNumber($F$49:$BN$55),$F
$49:$BN$55)

Hope this helps.

Pete

On Apr 11, 12:42 pm, Judy L wrote:
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

Wildcard in SumProduct
 

You're welcome, Judy - thanks for feeding back.

Pete

On Apr 11, 1:09*pm, Judy L wrote:
Thank you, thank you, it works perfect!

Judy



"Pete_UK" wrote:
If it always begins with FA-, try it this way:

=SumProduct((LEFT($B$49:$BJ$55,3)="FA-")*IsNumber($F$49:$BN$55),$F
$49:$BN$55)

Hope this helps.

Pete

On Apr 11, 12:42 pm, Judy L wrote:
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- Hide quoted text -

- Show quoted text -