Making Average() formula ignore months with too much blanks

[Mantask]

Hello everyone, I trying to make my Average() array formula ignore months, which have more than 5 blanks to simply ignore it, does anyone have a clue how to do this?
In the example that I show you, the second month should be excluded, because the values in column R have too much blank cells in that month.

P.S.
If using the blanks is too difficult, values in column N below 5 would respond in the same way (if there more than 5 cells with values less than "5").

[Tony Valko]

Try this...

Entered in S2 and copied down:

=IF(COUNTIFS(A$2:A$42,">="&T2,A$2:A$42,"<="&EOMONTH(T2,0),R$2:R$42,"")>5,"",AVERAGEIFS(R$2:R$42,A$2:A$42,">="&T2,A$2:A$42,"<="&EOMONTH(T2,0))*10^4)

[Mantask]

Thank you.

[Tony Valko]

You're welcome!