Summing up correct answers

**Coday** · 08-25-2009, 03:28 PM

I'm working on a spreadsheet where I have a row of cells with the correct answers to a test as letters (A, B, C and D). Then I enter in students' answers and add up the number of correct answers manually.

Is there a way to formulate a column of cells to compare the students answers to the row of correct answers and add 1 every time their answer matches the correct one?

Here's a screenshot of what I'm doing.

http://img299.imageshack.us/img299/5959/screen01e.jpg

Thanks for the help in advance!

**NBVC** · 08-25-2009, 03:35 PM

Try

=SUMPRODUCT(--(B5:Z5=B$2:Z$2))

copied down

**Coday** · 08-25-2009, 03:39 PM

What do you mean by copied down?

**Special-K** · 08-25-2009, 03:42 PM

Copy down column AA for each student row that exists.

**Coday** · 08-25-2009, 03:47 PM

It works! Many thanks!

**NBVC** · 08-25-2009, 03:48 PM

Originally Posted by Coday

What do you mean by copied down?

Activate the cell where you enter the formula.. and then click, hold and drag down the little black square at the bottom right corner of the cell.

**NBVC** · 08-25-2009, 04:02 PM

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save