Sumproduct Question
Bob,
Here is the formula;
=SUMPRODUCT((($A$35:$A$413=$A6)*(D$35:D$413=$B$7))/$C6)+SUMPRODUCT((($A$35:$A$413=$A6)*(D$35:D$413=$B $6))/$C6)
Column A is where the managers name is located
Cell A6 is the managers name
The 1st section of column D is the count for "yes" answers
The 2nd section of column D is the count for "no" answers
C6 is the store count under that manger
|