USE COUNTIF OR COUNTIFS and how?

[TGeorge2]

WANT

YEAR	MONTH	COUNT
2013	JUN	3
	JUL	2
2014	MAY	2
	APR	3
2015	JAN	2
	FEB	3

<tbody>
</tbody>

HAVE

Year	Month	ID
2013	JUN	1A1
2013	JUN	2B1
2013	JUN	5C3
2013	JUL	9H5
2013	JUL	8J6
2014	MAY	3G6
2014	MAY	8F5
2014	APR	9N4
2014	APR	3X6
2014	APR	9A2
2015	JAN	L0J
2015	JAN	M8H
2015	FEB	D7J
2015	FEB	X6U
2015	FEB	Y5G

<tbody>
</tbody>

 

[RickXL]

Hi,

A pivot table would probably be the easiest solution.

Choose Year and Month as the row variables then count the number of IDs.