View Full Version : SUMPRODUCT double counting

07-23-2013, 07:42 PM
Is there a way to use the SUMPRODUCT formula with 'OR' conditions and suppress the "double counting'?
Example. See attached worksheet. I want to count the number of rows where Mike is a member of the Bulls. 'Mike' can occur anywhere in columns B:E.
My SUMPRODUCT formula, however, is double counting each instance where Mike occurs in multiple columns. My formula in C16 returns 6. Should be 2.

07-23-2013, 10:48 PM


...compliments of Bob Phillips if it works, shame on me if it does not, but I am pretty sure I have it correct.

For an example, see: 3.4.1 Counting OR Conditions

in: SUMPRODUCT Step By Step - Part 3Hope that helps,