Count Names Based on Three Criteria

[BYates123]

I need to count names based on three different criteria. Column A lists employee names, Column B lists the month, Column C lists the year. I need to count the number of names that occur each month for every year, but each name can only be counted once. For example, I need to know how many names are listed under March, 2012, but I can only count that name if it is not used in January or February of 2012. This criteria for unique names only applies for the year, so if a name is listed only once in 2012 and 2013 then it is still unique for each respective year.

I tried the following use of "countifs", but wasn't sure how to create a code to satisfy the third criteria, which is that the name is not repeated previously in the calendar year. I feel like it shouldn't be too difficult but I can't figure it out!

<code>=countifs(C:C,"2012",B:B,"Mar",A:A...????</code>

 

[Jugantarji]

Have you thought of doing a pivot table and viewing the data like this?

There are a number of ways
You could have Years and Months on the left and names across the top. With say a count of Names as your values and then do a =COUNTIF(C6:H6,">"&1)

Count of Name	Column Labels
Row Labels	BOP	HXS	KGZ	RKM	VPH	XRL	Grand Total
2012		2	2	1	1	1	7
Jan		2	1				3
Feb			1		1		2
Mar				1		1	2
2013	2	1			1		4
Jan	1				1		2
Feb	1						1
Mar		1					1
Grand Total	2	3	2	1	2	1	11

<colgroup><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>

 

[Jugantarji]

Have you thought of doing a pivot table and viewing the data like this?

There are a number of ways
You could have Years and Months on the left and names across the top. With say a count of Names as your values and then do a =COUNTIF(C6:H6,">"&1)

Count of Name	Column Labels
Row Labels	BOP	HXS	KGZ	RKM	VPH	XRL	Grand Total
2012		2	2	1	1	1	7
Jan		2	1				3
Feb			1		1		2
Mar				1		1	2
2013	2	1			1		4
Jan	1				1		2
Feb	1						1
Mar		1					1
Grand Total	2	3	2	1	2	1	11

<tbody>
</tbody>

Sorry that countif should be =COUNTIF(b6:G6,">"&0)