View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Coderre
 
Posts: n/a
Default 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.