Solved

# Counting Correct Answers in Excel

Posted on 2012-09-09
360 Views
I am a teacher and I want to be able to give a test or quiz using a Google Docs Form that will save my students answers in a spreadsheet that I can open in Excel to see how they did. Is there a way to have Excel examine each answer (cell) and determine if it is correct or not? For example, I have 25 students and its a 30 question quiz and I add a row with the correct answers. I want the number missed displayed at the end of their answers.

Name   Q1  Q2  Q3  Q4  Q5......Q30   Total Missed
John      T     T     F    T     F ........T           2
Sam      F     F     F    F     T.........F           5
.
.
Answer T     F     T    T     F.........T

I looked at the CountIf and CountIfs functions but I kept getting errors. My formula looked something like this =CountIfs(B2,"<>"&B32,C2"<>"&C32.....)

0
Question by:FMezler

LVL 43

Accepted Solution

You can use a formula like

=SUMPRODUCT((A2:F2=\$A\$15:\$F\$15)*1)
0

Author Closing Comment

Works perfect!! Thank you so much!!!!
0

## Featured Post

### Suggested Solutions

excel forecast function 1 27
Copy paste as values 4 33
how to link excel with word 6 29
Search Box 13 24
Drop Down List with Unique/Distinct Values (enhancing the Combo-Box with a few steps and a little code) David miller (dlmille) Intro Have you ever created a data validation list from a database field or spreadsheet column (e.g., Zip Codes or Co…
Convert between Excel file formats (.XLS, .XLSX, .XLSM) with/without macro option David Miller (dlmille) Intro Over this past Fall, I've had the opportunity to see several similar requests and have developed a couple related solutions associate…
Viewers will learn the basics of slicers and timelines for both PivotTables and standard Excel tables in Excel 2013.
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.