Problem:
Columns B:F contain the answers (Y/N) to 5 questions from each of 7 students.
Each row includes the answers of one student.
We want to count the number of students who gave a certain answer (column H) a specific number of times (column I).
Solution:
Use the SUMPRODUCT and MMULT functions as shown in the following Array formula:
{=SUMPRODUCT(--(MMULT(--($B$2:$F$8=H2),{1;1;1;1;1})=I2))}
Bookmarks