Score System

HELP!

I need help with this asap. I am hopeless with excel!

I have a big spreadsheet of survey responses. I want to create a column at the end of the answers to the survey and give everyone a score based on their answers. There were 14 questions. If they answered a question they get a point, if their answer was 0 they don't get a point. So a person gets 6/14, the next person gets 10/14. I want a column to do it automatically for me! I hope this makes sense.

All of my answers are numerical, but some answers are like 500, I dont want a total column where its high numbers, just based on -/14

omg i got it

so i did =COUNTIF(A2:N2,".0")

this calculated the amount of 0 figure answers

then i created another column that did =14-O2 and dragged down and it got them all

there was probably an easier way but this was quick enough lol

It's a GREAT feeling when you find an answer on your own !

Good job.