Try the following formula which needs to be confirmed with
CONTROL+SHIFT+ENTER...

=SUM(IF(MOD(COLUMN($D$8:$L$57)-COLUMN($D$8),8)=0,IF(ISNUMBER(MATCH($D$8:$
L$57,{"ABC","LMN","QRS","XYZ"},0)),IF($F$8:$N$57=" W/M",1))))

or

=SUM(IF(MOD(COLUMN($D$8:$L$57)-COLUMN($D$8),8)=0,IF(ISNUMBER(MATCH($D$8:$
L$57,$P$2:$P$5,0)),IF($F$8:$N$57=$Q$2,1))))

....where P2:P5 contains ABC, LMN, QRS, and XYZ, and Q2 contains W/M.
The ranges can be adjusted to include other columns. Adjust them
accordingly.

Hope this helps!

In article ,
Bigfoot17 wrote:

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 D
UCT(($N$8:$N$57="W/M")*($L$8:$L$57={"XYZ","ABC","LMN","QRS"}))

Thanks for the help you have already been.