Forum Discussion
Formula to calculate percentage
Hi, I have two columns one is Question and the other is Response.I want to calculate the percentage of some questions whose response is "yes", out of the total responses of yes and no excluding n/a....
HansVogelaar are you mentioning this one ??
=COUNTIF(B2:B17, "yes")/COUNTIF(B2:B17,"<>n/a"), but I don't require all the cells in the range B2:B17.
=COUNTIF(B2:B17, "yes")/COUNTIF(B2:B17,"<>n/a"), but I don't require all the cells in the range B2:B17.
Take a look at the workbook that he attached in his latest reply. It contains a different formula!
Try this then:
=SUMPRODUCT((B2:B17="yes")*{1;0;1;0;1;0;1;0;1;1;0;1;0;1;0;1})/SUMPRODUCT((B2:B17<>"n/a")*{1;0;1;0;1;0;1;0;1;1;0;1;0;1;0;1})
- OK in that sheet another column was added, I can't add in my sheet because it goes to another teams as the responses change dynamically