Count the numbers of occurrences of month in the column

[sarinda100]

I have been stuck on a formula. Can anyone help me please? january count is wrong

 

[SunnyAlv]

Try with Sumproduct

=SUMPRODUCT(--(TEXT($A$2:$A$15,"mmm")=B2))

 

[etaf]

a blank cell is seen as jan - Jan 1900 , hence why that is counting blank cells
you could use
=SUMPRODUCT((TEXT($A$2:$A$100,"mmm")=B2)*(YEAR($A$2:$A$100)=2024))
if you wanted to include the year , or just
=SUMPRODUCT((TEXT($A$2:$A$100,"mmm")=B2)*($A$2:$A$100<>""))
BUT that would count any year and just the Jan month

Book1
	A	B	C	D
1
2	1/1/24	jan	2	2
3	2/1/24	feb	1	1
4	3/1/24	mar	1	1
5	4/1/24	apr	1	1
6		may	0	0
7	1/1/24	jun	0	0
8		jul	0	0
9		aug	0	0
10		sep	0	0
11		oct	0	0
12		nov	0	0
13		dec	0	0
14
15
16
17
18
19
Sheet1

Cell Formulas
Range	Formula
C2:C13	C2	=SUMPRODUCT((TEXT($A$2:$A$100,"mmm")=B2)*(YEAR($A$2:$A$100)=2024))
D2:D13	D2	=SUMPRODUCT((TEXT($A$2:$A$100,"mmm")=B2)*($A$2:$A$100<>""))

 

[sarinda100]

thank you very much u save my life man

 

[etaf]

you are welcome