Assuming col B houses: EE, SP, etc and col D contains the figures
we could do it in say, F1:
=SUMPRODUCT(($B$1:$B$10="EE")*($D$1:$D$10=10000))

Adapt the ranges to suit, but note that we can't use entire col references
(eg: A:A, B:B) in SUMPRODUCT
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"HRLADY" wrote:
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.