Hi

Yes, that would be the way to do it.

--
Regards

Roger Govier


"Bigfoot17" wrote in message
...
This was extremely helpful, and it appears I was so confused I was
making it
harder than it needed to be. However, I'd like to push the envelope a
bit
further ...

I need to evaluate several ranges for the "W/M" and corresponding
"XYZ" etc.
Would this be a matter of adding several SUMPRODUCTS together?
=SUMPRODUCT(($F$8:$F$57="W/M")*($D$8:$D$57={"XYZ","ABC","LMN","QRS"}))+SUMPRO DUCT(($N$8:$N$57="W/M")*($L$8:$L$57={"XYZ","ABC","LMN","QRS"}))

Thanks for the help you have already been.


"Toppers" wrote:

TRY:

=SUMPRODUCT(($F$8:$F$57="W/M")*($D$8:$D$57={"XYZ","ABC","LMN","QRS"}))

HTH

"Bigfoot17" wrote:

I am struggling!

This statement will count the number of "W/M"s that are "XYZ":
{=SUM(IF(($F$8:$F$57="W/M")*($D$8:$D$57="XYZ"),1,0))}

But what I would really like to know is the number of "W/M"s that
are "XYZ",
"ABC", "LMN", etc. I thought this would work, but it doesn't:
{=SUM(IF(ISNA(($F$8:$F$57="W/M")*($D$8:$D$57=OR("XYZ", "ABC",
"LMN",
"QRS"))),1,0))}

Any guidance is appreciated.