Help with formula to track attendance

[LinTal]

Hi,

I'm developing a spreadsheet through Google Docs that lists students in attendance per day of class (by date). The prerequisite for assessment is a certain number of days in class that increases as your level does. Would it be possible to make a formula that counts occurances attached to dates listed *after* a certain point? The steps after would be to have it notify me when a student is eligible to sit a test, and then to be able to change it to the new requirement as the level changes. My apologies, knowledge of excel formulas is limited for anything creative. Which is why I can't seem to make heads or tails of this one!

Thanks so much in advance.

 

[chrisguk]

If I read your goal correctly then maybe something like this would help.

It looks at Cell A:A and counts the amount of occurrences in that range. If the occurrences go over or match the given number "15" in this case then it displays they are eligible.

Hope this helps:

=IF(COUNT(A:A)>=15,"Eligible","Not Eligible")

 

[LinTal]

That's wonderful, thank you! I'd been looking to show eligibility between certain dates, all that was left to do was combine the one you gave me with one I was trying to tweak earlier (=COUNTIF('Form Attendance Data'!E2:E,"*Student*")). Cheers for that!!