count criteria excell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
with some data in a5:f7 (col a names, col b year, col c:f with some "*"), and
listing year desired in cell b9, I used this formula to count occurrances of
"*" in c5:c7, where year in b5:b7 was <= year in cell b9

=SUMPRODUCT(($B$5:$B$7<=$B9)*(C$5:C$7="*"))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Counting multiple memberships 1
How can I count deviations between two rows? 3
Excel Need Countifs Formula Help 0
Counting items in one column based on criteria in another column 3
count cells across muliple columns 3
Counting dates with specific criteria 1
Comparing, counting, if, sum... help... 3
Count with multiple criteria / combination 1

Back
Top