Thread
:
sumproduct with wildcard for text?
View Single Post
#
4
Posted to microsoft.public.excel.worksheet.functions
Jarek Kujawa[_2_]
external usenet poster
Posts: 896
sumproduct with wildcard for text?
try:
=SumProduct(($B$1:$BJ$5="high")*(LEFT($F$1:$BN$5,1 1)="requirement"))
Reply With Quote
Jarek Kujawa[_2_]
View Public Profile
Find all posts by Jarek Kujawa[_2_]