# Tallying a multiple choice test

1. ## Tallying a multiple choice test

Columns represent each student's test (There are 31 test numbers)
The test consisted of 50 multiple choice questions, each listed in each row. The green column shows the correct answer for each question.

I need to tally the score for each test in the orange row. How do I tally by checking each answer against the correct answer? (The three tan columns should have the highest scores) Thank you in advance.

2. ## Re: Tallying a multiple choice test

In B52 copied to the right, enter this ARRAYED formula

=SUM(--(B2:B51=\$AG\$2:\$AG\$51))/50

...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer. Press F2 on that cell and try again.

3. ## Re: Tallying a multiple choice test

Worked great, thanks

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

#### 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