Count percentage of specific text in a range of cells

  • Thread starter Thread starter kruggie2000
  • Start date Start date
K

kruggie2000

I am trying to figure out how get the percentage of times a specific text
occurs in a spreadsheet.
 
You can get the number of times it occurs by using COUNTIF function

For example to count how many times Test occurs in Col C use
=COUNTIF(C:C,"Test")

You can then calculate the percentage as you want.
 
Back
Top