Try: =SUMPRODUCT((A2:A10="y")*(B2:B10<""))

Success? Celebrate it, click the YES button below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:25,000 Files:300 Subscribers:70
xdemechanik
---
"Becca" wrote:
I am creating a training matrix and need help with a formula.

Tracked on scorecard Training Date
y 7/10/03
y (blank cell)
n 8/10/03
n (blank cell)

I need to create a formula that counts the number of employees that took the
training, but only if they are tracked on the scorecard (y).