|  

» Counting the Number of YES Responses in a Student Questionnaire

CATEGORY - Counting VERSION - All Microsoft Excel Versions
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))}



Rate This Tip
12 34 5
Rating: 2.50     Views: 13481
Screen Shot
walkerdayle
Can a screen shot be added to this? I'd really like to see this example.
Thank you:) :)
Click here to post comment
For Registered Users
Name
Comment Title
Comments