You can count the number of cells that match a specific string using countif:
=countif(a:a,"Broker")

"Tom B" wrote:

I need to find a formula that will allow me to add words in a column and only
the specific words i want.

iEx. in a column i will have the words: Broker, Agent, Agent, Agent, Loan
Officer, Agent, Loan Officer. I need the formula to add and total the
number of Brokers and Agetns that are there and not the Loan Officers.