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.