Sumproduct. count how many time a month appears (in column filled by date or text). #Value

Hi adriend,

welcome to the forum.

try using below formula which need to be entered using ctrl shift enter key combination:-

Formula:

=SUMPRODUCT(IFERROR((ISNUMBER(M7:M75))*(MONTH(M7:M75)=11),""))

Regards,
DILIPandey
<click on below * if this helps>