Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 366
  • Last Modified:

Counting Correct Answers in Excel

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

Thanks in advance!
0
FMezler
Asked:
FMezler
1 Solution
 
Saqib Husain, SyedEngineerCommented:
You can use a formula like

=SUMPRODUCT((A2:F2=$A$15:$F$15)*1)
0
 
FMezlerAuthor Commented:
Works perfect!! Thank you so much!!!!
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now