<div>
Works perfect!! Thank you so much!!!!
</div>


<div>
<div class="content wysiwyg-content">
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.<br />
<br />
Name &nbsp; Q1 &nbsp;Q2 &nbsp;Q3 &nbsp;Q4 &nbsp;Q5......Q30 &nbsp; Total Missed<br />
John &nbsp; &nbsp; &nbsp;T &nbsp; &nbsp; T &nbsp; &nbsp; F &nbsp; &nbsp;T &nbsp; &nbsp; F ........T &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2<br />
Sam &nbsp; &nbsp; &nbsp;F &nbsp; &nbsp; F &nbsp; &nbsp; F &nbsp; &nbsp;F &nbsp; &nbsp; T.........F &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 5<br />
.<br />
.<br />
Answer T &nbsp; &nbsp; F &nbsp; &nbsp; T &nbsp; &nbsp;T &nbsp; &nbsp; F.........T<br />
<br />
I looked at the CountIf and CountIfs functions but I kept getting errors. My formula looked something like this =CountIfs(B2,&quot;&lt;&gt;&quot;&amp;B32,C2&quot;&lt;<wbr />&gt;&quot;&amp;C32....<wbr />.)<br />
<br />
Thanks in advance!
</div>
</div>


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!

Counting Correct Answers in Excel

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.