What syntax do I use when adding up the number of correct answers that have boxes checked? My question is;In this example the correct answers are Cotton and Calico.I award the students a total of 2 marks ( 1 mark each) in selected. Therefore if a student selects Denim, Satin or Silk, they do not get a mark.The current Syntax I have been using is something along the lines of;=if(D2=Cotton., 1, 0, Calico., 1, 0, Demin., 0, 0, Satin., 0, 0, Silk., 0, 0)
How to add up the correct answers from the check boxes question?
google spreadsheets;google forms