Ok heres the problem:

Column B contains dates in the format of "DD-MMM-YY"

Column N contains ticks if the case is true: (the formula to generate: =IF(AND(B17 >= $G$5, B17 <= $G$6),"a","") - this generates the ticks i think usin a different font.

I need a formula which will: if the month between B17 to B200 = "Apr" (for example), then count the number of ticks in column N.

See I told you it wasn't straightforward Pleeeeaaassseee help if you know how! Thankkksssss in advance...