On Sheet2 I have a table which among it's columns has a column with the date, named tblDates (of the score on a test).

I then created another column that displays the month of the afore-said date which is then named tblTestMonth.

This was done so on another sheet, Sheet1, I can use a COUNTIFS() that uses a month as one of the conditions, so any month in question, qryMonth, which for instance might be the number 11 for November, sort of like =COUNTIFS(tblTestMonth, qryMonth).

I know there has to be a better way to go directly after the date without the created table and array of months, but when I try something along the lines of =COUNTIFS(MONTH(tblDates), qryMonth) it does not work, as I expected it wouldn't for I know I missed a step, I just don't know what the heck that step is.

Though I could get by with it the way it is, when I then wish to expand the system to also accommodate the year of the test it would force me to now also create a table column for the year and that is getting way too sloppy and just plain wrong.

Would someone be so kind as to enlighten me?