Formula to create percentages based on words instead of numbers

[stixmike]

I suppose this would be an if-then statement. This is what I'm trying to do:

I have a column with a few dozen rows that have three different words used to evaluate performance - one word per row. At the end of the table I want to be able to automatically tally the percentage that each word occurred in the column. Can anyone help? This is probably very simple but I'm not sure how to do it.

[Miraun]

Could use CountIF / Count

So... =Countif(A:A,"Value I care about") / Counta(A:A)

[stixmike]

Thank you for the reply. That helps. But what if I wanted the data to appear in a separate column (not the bottom of the column that I am tallying)?

[stixmike]

Oh nevermind, I see what that does. Perfect. Thanks!