Now, how do I get a count based on the same conditions?

Try: =SUMPRODUCT(--(E8:E100="PCO"),--(F8:F100=""))
(w/o the col G range)

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----