Hi, did you try COUNTIF?

Assuming that the 10,000 are on the column D, "=contif(d2:d1000,"10000")

hope it helps

Marcelo - Brazil



"HRLADY" escreveu:

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.