In Excel, How do i add Words together.
Let's try this one piece at a time, then you can combine them later:
With your list in Cell A1.
Count of Agent is...
B1: Agent
C1: =(LEN(UPPER(A1))-LEN(SUBSTITUTE(UPPER(A1),UPPER(B1),"")))/LEN(B1)
Count of Broker is.....
B2: Broker
C2: =(LEN(UPPER(A2))-LEN(SUBSTITUTE(UPPER(A2),UPPER(B2),"")))/LEN(B2)
Does that help?
***********
Regards,
Ron
"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.
|