I made a questionnaire with 100 statements. The participants can score in a range from 0 (I don’t agree at all) to 5 (I totally agree). Now I want to calculate the percentage from the scores 4 & 5 on each statement. (for example 17% of the participants agree to this statement)

Is there someone who can give me the excel formula to calculate it easily?

Statement 1S 2S 3S 4 …S 100214 324 135 243 44NO ANSWER 344 532 5NO ANSWER2 544 044 12NO ANSWER 315 205 203 444 NO ANSWER54 243 43NO ANSWER 425 225 324 352 442 123 34,80%43,50%61,90%

### Best answer

Hi Santoul,

While I don’t know of a formula for this off the top of my head, maybe this page will be helpful for you: http://www.excelfunctions.net/Excel-Formulas.html

You could sort your columns so that it’s easier to see exactly how many 4s and 5s you received and put that over the total number of responses. Then a bit of division would give you the percentage. Of course, that’s a bit long-form compared to having Excel do this for you but it’s an option.

I hope this helps,

Chris

*×*