Count words in a range

I want to count the frequency words in a given range of cells. My target range if a list of the names of hospitals. I want to be able to identify rare words such that these rare words help me identify the hospital name I am looking for. Ideally I would like to create a separate worksheet with 2 columns: words and frequency. So for example:

If my range has two records: "Parkland Memorial Hospital" and "Parkland Hospital Outpatient Services" I would get a worksheet with

Parkland 2
Memorial 1
Hospital 2
Outpatient 1
Services 1

I have played around with COUNTIF but I am having type the name I am looking for, like =COUNTIF(RANGE, "Parkland") but I am wanting to do this programatically.

Thanks

Can't get it to work. When I DateRange to the name of my Range in the spreadsheet it generates cryptic error. I can't image why this is so hard. Oh well thanks for trying.