Select this cell, and click Home > Percent Style to convert the decimal number to percentage.ģ. Enter this formula: =COUNTIF($B$2:$B$16,D2)/COUNTA($B$2:$B$16) into your specified cell, and press Enter key, and then you will get a decimal number as following screenshot shown:Ģ. Take the above data for example, you can quickly find the percentage of a specific option with following formula.ġ. The COUNTIF and COUNTA functions can be combined to get the percentage of a specific value in a range of data in Excel. This article, I will talk about how to get the percentage of a specific option in a range.Ĭountif and calculate the percentage of a specific value with formula That is to say, I need to know the option A accounts for the percentage of all options. For example, I have a summary report of a research paper, and there are three options A, B, C, now I want to calculate the percentage of each theses three options.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |