Need Help with Formula

[Becca]

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).

 

[Max]

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

 

[Dennis Tucker]

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