Max, its worked here.
Marcelo - Brazil

"Max" escreveu:

"HRLADY" wrote:
It didn't work it gave me 0. Also note that the figure with numbers verify. I
want the number of EE's that have any amount in the other column.

Try instead in say, F1 something like:
=SUMPRODUCT(($B$1:$B$10="EE")*($D$1:$D$10<""))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---.