Count percentage of specific text in a range of cells

K

kruggie2000

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

Sheeloo

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro to select and delete levels of a document 2
Percentage of Weight Loss/Gain 4
Macro to Select text from a point given to a specific word 2
Get percentage of whole 2
Percentage Increase 11
Need Help with a VBA subroutine 0
Calculating percentage growth rate from a cumulative figure 4
Needs help combining functions. 3

Top