How to find out what is more filled in excel?

Question

excel

I have a column in which a certain word is filled in on each line (the name of the sales sites: Shop, VK, TIU) I need to find out how many of the existing (roughly speaking 100 lines) percent are occupied by the word VK, TIU, Shop each. Roughly speaking, I want to see it like this:

Answer 1

Pivot tables do this.

Answer 2

You can use the COUNTIF and COUNT formula. Count
how many rows you have in the array with the word "Store" and divide by the number of all terms. Get a share of "Stores" in the general list.
And so on across all their sites