+ Reply to Thread
Results 1 to 2 of 2

Counting the Number of YES Responses in a Student Questionnaire

  1. #1
    Forum Contributor
    Join Date
    12-07-2004
    Posts
    596

    Counting the Number of YES Responses in a Student Questionnaire

    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))}


  2. #2
    Registered User
    Join Date
    05-28-2004
    Location
    New York City
    Posts
    20

    Screen Shot

    Can a screen shot be added to this? I'd really like to see this example.
    Thank you

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1