Saturday, July 26, 2014

yogi_Compute Total Score Row By Row From Form Submissions With Correct Answers In Row 2 And Specified Scoring Strategy

                            Google Spreadsheet   Post  #1709
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Jul-26-2014
post Peter Hegen Stewart:
(https://productforums.google.com/forum/#!category-topic/docs/spreadsheets/0JTCc7b_3jM)
Calculate total correct answers over a range

I want to tally the total correct answers for each form submission.

Currently the second row (A2:CS2) has the model answers. So I'll compare new submissions to this row.

I am currently using the formula below in column CT to get the desired result.

=sum(
if(exact($B$2,$B5),1,0),
if(exact($C$2,$C5),1,0),
if(exact($D$2,$D5),1,0),
...
if(exact($CQ$2,$CQ5),1,0),
if(exact($CR$2,$CR5),1,0),
if(exact($CS$2,$CS5),1,0),
)

So a correct answer scores 1 and a wrong answer scores 0 and those are added up.

Is there a more concise way of doing this?

Thank in advance,
Peter
------------------------------------------------------------------------------------------------------