Thank you for pointing out this bug. I do have a work-around for you:
change your original formula from:
= COUNTIF(A1:P1, "correct")
= SUM(IF(A1:P1 = "correct", 1, 0))
I hope this helps,
Thank you very much for the help and quick reply.
It looks like we are getting closer. I changed the formula as you recommend and now it is carrying the formula from one row to the next correctly when we add new responses to the data set. However, it appear to only be counting the first column/question. If they get the first question correct it places a “1” in the quiz score column, and if they get the first answer incorrect it places a “0”. It does not appear to be adding up all the responses in the range provided in the formula. Did you test this formula? Did it work for you if you have a range of cells/question it should be summing? Maybe it is something I’m doing wrong, but I have tripled checked to make sure I’m typing in the formula as you recommend. Any additional help would be greatly appreciated. I feel we are very close to a solution.
It sounds like you're dealing with columns that correspond to likert fields. If so, you've run accross a recently discovered bug that I intend on getting fixed for the next release, which I believe will be in a couple of weeks.