Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumproduct help using wildcard | Excel Discussion (Misc queries) | |||
Sumproduct + wildcard | Excel Worksheet Functions | |||
SUMPRODUCT WITH WILDCARD | Excel Discussion (Misc queries) | |||
SumProduct w/WildCard | Excel Worksheet Functions | |||
wildcard in sumproduct? | Excel Worksheet Functions |