Count if.

[amirshaneh]

hello guys.

im not really sure if its possible but i want to ask anyway.

i got a row that contain a full year and it changes a day each 24 rows.. with the formula
=40855+INT((ROWS($A$2:A2)-1)/24)

i wanna know if there is an option to do a montly check on how many times a certain word is apeared in another certain row and i need it to count it montly.
for example if in the current month it shows that word 18 time out of the whole month so it will show 18 in the count.

its pretty complecated for me to explain so i attached an example on how it should look.

i really hope its possible.
thanks in advance.
Amir.