I think you need to give a clearer outline of the data layout, please.
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"clarknv" wrote in message
...
My spread sheet has my students name, the the date of the class(2 months
total) to the right with 3 items listed under each day (acrf, coachings,
attendance). I would like to count the number of times someone has been
coached. The problem is that the name could be different for each
coaching.

How can I count the number of coachings if the criteria can be different
and
the criteria is selected from a data validation list?