Scoring a True-False Test

  • Thread starter Thread starter phillyfan
  • Start date Start date
P

phillyfan

I'm guessing there is a very easy solution to this but just haven'
figured it out yet. Hopefully someone can help.

I have a 20 question True-False test. The answers will be placed in B
to U4 as "T" or "F". The test-takers' answers will then be placed i
the rows underneath it then. I've worked out conditional formatting t
highlight correct answers in the columns but can't seem to figure ou
how to count correct answers for each individual and place that answe
to the right of the test takers' answers (column V). Logically, to me
it looks like if C4=B4 then that counts for 1, if C4 does not = B4 tha
its 0. Then same for C5 and B5, then D5 and D4 etc... The sum i
then made and reported in column V. I just can't seem to find th
formula to make it work.

The other way I was looking at is to count left to right if th
conditional format (the highlighting) is applied and count those an
place that value in V.

Any help is greatly appreciated.

Thank
 
One solution is to just add another row under a test-taker's answers (I
Student1 answers on row 5, have a row that flags correct and incorrec
answers) using the following formula:

=IF(B5=B4,1,0) where 1s mark a correct and 0s mark an incorrect

Then it's just an easy sum from B6:U6 to get total correct
 
Thanks rbrychckn,

That did the trick. It was a bit time consuming to type in but works
perfectly.


Thanks.
 
Back
Top