A B C D
1 C1 EE K1 10,000
2 CE SP K2
200,000
3 C1 EE K1
10,000
4 CE EE K2


=SUMPRODUCT((B1:B4="EE")*(D1:D40))

You get an answer of 2. There are two enterys where EE is in colulmn B
and there is a dollar value colulmn D.



You will obviously need to change B4 and D4 to whatever it is that you
need it to be.