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.

"kruggie2000" wrote:

I am trying to figure out how get the percentage of times a specific text
occurs in a spreadsheet.