Frequency Distribution or something else?

[badfrog]

Hi not super Excel savvy so apologies if this is an easy question (or makes no sense). I have 10 columns of text info (school names). What I would like to do is see how many times a school is in each column. I thought a frequency dis. would do the job however its not working. Very possible because I'm doing it wrong, who knows. I also heard of pivot tables-any ideas/suggestions?

Thanks happy Friday!