Count IF function

we creating quiz last column in response file having formula provides total count of how many questions student go correct.  particular quiz rather assigning values of “1” , “0”, of correct , incorrect responses, have done pass quizzes, needed assign values of “correct” , “incorrect”.  wrote countif formula (=countif(a1:p1, “correct”) ) works great on first row.  tells how many responses student got correct.  problem when new response comes in , response files adds new row, formula although it  appears copy correctly onto next row, not work in next row, rather shows same answer first row.  have tried in several test forms same result.  countif formula appears work correctly when working columns rather rows.  there magic trick getting work when counting responses in rows.  again can work great if there 1 response (row) when have multiple responses (rows) formula not copy on correctly, add 1 specific row , past same answer in rows regardless of how many responses have.

hello jb7777,

 

thank pointing out bug.  have work-around you:

 

change original formula from:

= countif(a1:p1, "correct")

to:

= sum(if(a1:p1 = "correct", 1, 0))

 

i hope helps,

marco

More discussions in Archived Spaces

adobe