View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
clarknv clarknv is offline
external usenet poster
 
Posts: 10
Default count occurances in a row using multiple criteria

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?