Hi, petteri,
it's a typical "GIGO" (Garbage in - Garbage out) error, which nobody of us would have found without seeing your survey.
Your codes in question q4 are °1°, "2", "3", "4", but in the equation you compare with "A1", "A2",...
So, either you change your equation accordingly:
Bucket 1: sum(if(q4 == 4, 1, 0), if(q5 == "A4", 1, 0), if(q6 == "A1", 1, 0), if(q7 == "A4", 1, 0))
or you change the codes of question q4.
Joffm
Volunteers are not paid.
Not because they are worthless, but because they are priceless
The topic has been locked.