Need help with scoring a questionaire and if statements please.

New Contributor

Good day Gurus,


I am trying to create an "IF" formula for scoring a questionaire, and not figuring it out.


I have a 10 question survey, 4 answers possible, yet the scoring gets confusing:

Items 1, 3, 4, 7, 10  scored. 4 point, 3 points, 2 points, and  1 points. 

Items 2, 5, 6, 8, 9 are reverse scored. 1 point, 2 points, 3 points, and  4 points. 


Then I add the scores, that part I know how.  Thank you for your help.

2 Replies
best response confirmed by Hans Vogelaar (MVP)



If you want to add the points for the actual answers you can try above formula. Enter the formula with ctrl+shift+enter if you don't work with Office365 or 2021. There should be a single formula to calculate the points total but i can't figure it out at the moment.



The IF formula works as well in my spreadsheet.

Thank you so very much, I was beating my head against the wall trying to figure it out. I forgot I needed multiple if statements. Thank you a million times!