Take the 2-minute tour ×
Web Applications Stack Exchange is a question and answer site for power users of web applications. It's 100% free, no registration required.

I have a row containing an answer key for a multiple choice exam and then below that a number of rows containing the answers from students.

A very simple question: how can I count the number of "matches" between each student response row and the answer key row?

Example:

Answer key | 1 | 2 | 1 | 1 | 4 | 3 |
Bob        | 1 | 1 | 1 | 1 | 1 | 1 | <some formula magic that would give me '3'>
Steve      | 2 | 4 | 2 | 4 | 3 | 2 | <some formula magic that would give me '0'>
Jen        | 1 | 2 | 1 | 1 | 4 | 3 | <some formula magic that would give me '6'>
share|improve this question
1  
Please add your answer as an answer and accept it. –  Franck Dernoncourt Dec 15 '13 at 2:54
add comment

1 Answer

up vote 0 down vote accepted

This did the trick for me: =arrayformula(sum(B$1:G$1=B2:G4))

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.