I have student names in column 1, graduation date in column 2, and
participation in various school clubs (indicated by an astrics) in columns
3-6. I want a formula that will count the number of students in each club per
year (eg How many students were in club x (column 3) in 1998?)

I have tried to set up dcount and count if formulas, but I'm not getting
something right. Any help, anyone??? Your time is really appreciated!