View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
HRLADY
 
Posts: n/a
Default Counting the number when you have a number and text

I have a column for EE or SP and a column that has an amount of insurance
coverage like 10,000 etc.

I want to count the total number of EE have that level or type of coverage

My columns are like this:
C1 EE K1 10,000
CE SP K2 200,00

I have tried numerous formulas from the various discussions and I can't find
any that works.