I'm using Google Forms to collect some data from students. Each time a new student submits a form, the data (4 columns worth) is added to a new row in a Google Spreadsheets, bumping anything previously in that row. It will also replace any formulas I have written in columns outside of the data range (they'll be left blank).

Note: because I am using certain features (trigger script upon submission) of the AutoCrat script I have to do all this in the old versions of Google Forms & Spreadsheets...

I have been able to "score" each results by adding an answer key as the first form submission in row 2 and then comparing incoming answers to it with an ArrayFormula in columns G to J (e.g., =ARRAYFORMULA(IF(C3:C=C$2,1,0)) and so one for each column to be scored).

However, I've run into a problem, since I can't seem to write an ARRAYFORMULA to place in column K that simply sums the row from columns G-J. I've tried lots of ways, but I'm sure the syntax is just off. Does anyone know a way?

I've read this, and this, and this, but they haven't helped.

Here is an MWE of the Form and Spreadsheet

Data goes into columns A-F, the data in C-F is scored with ArrayFormulas in G-J and a flubbed attempt at summing the scores is in column K. Feel feel to edit the file.


1 Answer 1


Please try:


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.