![]() ![]() ![]() In the above formula, B2:B15 is the list of cells which contain the specific text you want to calculate the percentage Ģ. Then you should change this cell format to percent, and you will get the result you need, see screenshot:ġ. Enter this formula: =COUNTIF(B2:B15,"Yes")/COUNTA(B2:B15) into a blank cell where you want to get the result, and then press Enter to a decimal number, see screenshot:Ģ. To get the percentage of a specific text from a list of cells, the following formula can help you, please do as this:ġ. How could you calculate the percentage of yes and no text from a list of range cells in Excel worksheet? Maybe this article will help you to deal with the task.Ĭalculate the percentage of yes and no from a list of cells with formula How to calculate the percentage of yes and no from a list in Excel?
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |