response automatically added sheet "form responses". want apply formulas in sheet called "student answers". however, "student answers" doesn't auto-update submitted responses. here formulas trying use:
='form responses'!a1 etc. =if('form responses'!e6='answers'!$e$2,1,0) "answers" sheet answer key =sum(d5:i5) sums numbers given in previous formula.
basically, have created quiz, , want grade quiz on separate sheet. here sheet in question: https://docs.google.com/spreadsheet/ccc?key=0aqvtp4ajjrsudglqndv5cud4tvfmefb3tndjetblble&usp=sharing
thanks help.
the solution use =arrayformula. here working examples:
=arrayformula('student submissions'!a:c) basic copying of columns
=arrayformula(if('student submissions'!d3:d='student submissions'!d3,1,0)) if statements
=arrayformula(mmult(d3:i;transpose(sign(column(d3:i))))) sum
=arrayformula(j3:j/6*100) average , percent
note: found these answers in google product forums cannot find link again.
Comments
Post a Comment