Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Physics
Chemistry
Biology
Mathematics
English
Economics
Psychology
Social Studies
Fashion Studies
Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
How to Calculate the Percentage of Yes and No from a List in Excel?
Suppose you have a list of "Yes" and "No" values in an Excel sheet and you need to calculate how many "Yes" and "No" are there in percentage terms. In this tutorial, we will show a simple method that you can use for this calculation.
Step 1
Open a Microsoft Excel sheet, and enter the below status shown in the screenshot below for your reference. You can give status as per your wish.
Step 2
Now you need to enter the below given formula in the blank cell where you want the result of the yes percentage, and then press the Enter key, as shown in the following screenshot.
=COUNTIF(B2:B14,"Yes")/COUNTA(B2:B14)
Step 3
Now you need to enter the below given formula in the blank cell where you want the result of the no percentage, and then press enter key as shown in the below screenshot for your reference.
=COUNTIF(B2:B14,"No")/COUNTA(B2:B14)
Step 4
If you do not see the result in a percentage format. Then you need to go to Home and then under the number tab select the percentage symbol to get the result in the percentage format. Before that select the result and then click on the percentage symbol. Kindly find the below screenshot for your reference.
In the above formula, B2:B14 is the list where you want to calculate the percentage of yes and no. Make sure you do not give any spaces in between the values, as the formula will give you the result as zero.
Conclusion
In this tutorial, we used a simple example to show the easiest way to calculate the percentage of Yes and No from a list given in an Excel sheet.
1K+ Views
