Becca,

I'm a little confused about what you want. You said you want to count
employees but the same you provided only has two headings, some y/n's and
some dates. Are you saying you want to count dates? Or y's? Or what?


Dennis

"Becca" wrote in message
...
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).