Thread
:
Wildcard not working in SumProduct Array
View Single Post
#
2
Posted to microsoft.public.excel.misc
Don Guillett[_2_]
external usenet poster
Posts: 1,522
Wildcard not working in SumProduct Array
More info on your layout
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"Roady" wrote in message
...
Hello:
I am trying to accomplish a SUMPRODUCT (count as 1) if a line of data
meets
the following criteria:
C=205
D=Australia
F=Yarn
G contains -
H contains -
I contains -
M=zero
Here's the formula I am using - most pieces are working except the portion
regarding columns G/H/I:
=SUMPRODUCT(--(C17:C65535=205),--(D17:D65535="Australia"),--(F17:F65535="Yarn"),--(G17:G65535="*-*"),--(H17:H65535="*-*"),--(I17:I65535="*-*"),--(M17:M65535=0))
I have tested it and it seems to work until I add the G/H/I columns with a
wildcard in. The formula DID work when I had G/H/I equal a specific value
that was not a wildcard.
Any help is appreciated! Thank you!!
Reply With Quote
Don Guillett[_2_]
View Public Profile
Find all posts by Don Guillett[_2_]