Countif Month for Attendance Sheet

[NCF11]

I am making an attendance sheet to count the number of times a person is present in a certain month. (url to photo of sheet attached)

Column A is Dates, and Columns C-D lists "yes" if present on that date and "no" if not present on that date.

Column G lists months (Feb, Mar, April..), and in Columns I-K, I want to count the number of times "yes" appears in the corresponding column in a certain month.

I am having trouble using the Month() function inside the Countifs() function.

-Thanks!

NCF


EDIT: Sorry, this is the url to the photo: https://postimg.cc/QVjb3X57

 

[Eric W]

Welcome to the Board!

You can't use MONTH() inside a COUNTIFS functions, at least not the way you're envisioning. Instead you need to create 2 conditions, one for the start date, and one for the end date. If your dates in column G are actually the 1st of each month, then try:

Book1
	A	B	C	D	E	F	G	H	I	J	K
1			Person	Person	Person				Person	Person	Person
2	Date		1	2	3		Date		1	2	3
3
4	4-Feb-19		No	Yes	Yes		Feb-19		0	2	2
5	11-Feb-19		No	Yes	Yes		Mar-19		0	2	2
6	11-Mar-19		No	Yes	Yes		Apr-19		0	3	3
7	21-Mar-19		No	Yes	Yes
8	1-Apr-19		No	Yes	Yes
9	22-Apr-19		No	Yes	Yes
10	29-Apr-19		No	Yes	Yes
Sheet1

Cell Formulas
Range	Formula
I4	=COUNTIFS($A:$A,">="&$G4,$A:$A,"<="&EOMONTH($G4,0),INDEX($C:$E,0,MATCH(I$2,$C$2:$E$2,0)),"Yes")

If you want to use MONTH(), then you could use SUMPRODUCT instead of COUNTIFS, but that requires a different approach.