Hi
I want to count the number of student entries in a competition per month.
I've set up the attached spreadsheet with the entries in Columns A (A3:A102) and B (B3:B102) with enough space for potential entries till the end of the year.
In Columns E and F I've got the calculations.
Unfortunately, the formula for January seems to add the blank cells. The rest of the months seem to be OK.
Can someone please help me with the formula for Jan?
Bookmarks