COUNT 'YES' BY MONTH & YEAR WITH ANOTHER CONDITION

[Unlucky]

Trying to count the number of 'Yes' entries by month and by a program. Raw information is contained in columns M23:R47

Column M23:M47 contains the program name
Column N23:N47 contains the entry dates
Column O23:O47 contains the 'Yes' and 'No' entries (Primary)

Column P23:P47 contains the 'Yes' and 'No' entries (Alternate - ignore for the purposes of the post)
Column Q23:Q47 contains a workcenter identification (ignore for the purposes of the post)
Column R23:R47 contains an employee identification (ignore for the purposes of this post)

I am currently using the formula =COUNTIFS($M$23:$M$47,"="&$M4,$N$23:$N$47,"="&O$3,$O$23:$O$47,"=Yes") . . . but only some cells report to the table.

The report table is columns M3:Z19

Column M3:M19 contain the program names
Row N3:Y3 contain the month & year
Cells N4:Y17 contain the formula

Column Z4:Z18 are totals of the cell rows, the same as ROW N18:Y18

PROBLEM: Only some of the data is reporting in the cells using the formula =COUNTIFS($M$23:$M$47,"="&$M4,$N$23:$N$47,"="&O$3,$O$23:$O$47,"=Yes")

Tried to upload a sectioned copy of the spreadsheet but can't figure it out.

 

[Unlucky]

TEST LOG FOR FORMULAS.xlsx
	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z
2	PE METHOD
3	PROGRAM	Jan-21	Feb-21	Mar-21	Apr-21	May-21	Jun-21	Jul-21	Aug-21	Sep-21	Oct-21	Nov-21	Dec-21	TOTAL
4	A	0	0	0	0	0	0	0	0	0	0	0	0	0
5	B	0	0	0	0	0	0	0	0	0	0	0	0	0
6	C	0	0	0	0	0	0	0	0	0	0	0	0	0
7	D	0	0	0	0	0	0	0	0	0	0	0	0	0
8	E	0	0	0	0	0	0	0	0	0	0	0	0	0
9	F	0	0	0	0	0	0	0	0	0	0	0	0	0
10	G	0	0	0	0	0	0	0	0	0	0	0	0	0
11	H	0	1	0	0	0	0	0	0	0	0	0	0	1
12	I	0	0	0	0	0	0	0	0	0	0	0	0	0
13	J	0	0	0	0	0	0	0	0	0	0	0	0	0
14	K	0	0	0	0	0	0	0	0	0	0	0	0	0
15	L	0	0	0	0	0	0	0	0	1	0	0	0	1
16	M	0	0	0	0	0	0	0	0	0	0	0	0	0
17	N	0	0	0	0	0	0	0	0	0	0	0	0	0
18	TOTAL	0	1	0	0	0	0	0	0	1	0	0	0	2
19	PERCENTAGE	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%
20
21	PROGRAM	DATE	METHOD		WORKCENTER	OPERATOR		COUNT PE METHOD BY MONTH, BY PROGRAM
22			PE	PR
23	A	7-Jan-2021	Yes	No	14	2571
24	A	12-Jan-2021	Yes	No	12	4528
25	D	31-Jan-2021	Yes	No	12	1448
26	G	6-Feb-2021	No	Yes	12	1542
27	H	22-Feb-2021	Yes	No	7	7201
28	N	4-Mar-2021	Yes	No	14	2571
29	N	18-Mar-2021	No	No	5	1542
30	M	12-Apr-2021	No	No	22	1448
31	F	1-May-2021	No	No	17	7201
32	G	3-May-2021	Yes	No	17	2571
33	B	7-May-2021	No	Yes	17	2571
34	B	19-May-2021	Yes	No	14	1448
35	K	6-Jun-2021	Yes	No	12	3309
36	A	4-Jul-2021	Yes	No	2	2571
37	A	21-Jul-2021	Yes	No	7	3309
38	B	21-Aug-2021	Yes	No	7	1448
39	C	23-Aug-2021	Yes	No	7	7201
40	L	22-Sep-2021	Yes	No	8	7205
41	J	24-Sep-2021	Yes	No	2	1448
42	J	29-Sep-2021	No	Yes	14	3302
43	N	30-Oct-2021	No	Yes	12	1448
44	M	11-Nov-2021	Yes	No	12	2571
45	K	27-Nov-2021	No	Yes	17	1542
46	A	7-Dec-2021	Yes	No	8	1888
47	C	25-Dec-2021	No	Yes	2	1369
FORMULA TEST

Cell Formulas
Range	Formula
M3,M21	M3	='C:\Users\BGD1558\OneDrive - Defense Information Systems Agency\Documents\BAE SYSTEMS (06085)\CORRECTIVE ACTION PLANS\[LOG_BAE_(06085)_OPEN-CARs_REVISED_DRAFT_2021-11-04.xlsx]DROP DOWNS'!$F$4
N4:Y17	N4	=COUNTIFS($M$23:$M$47,"="&$M4,$N$23:$N$47,"="&N$3,$O$23:$O$47,"=Yes")
Z4:Z17	Z4	=SUM(N4:Y4)
N18:Z18	N18	=SUM(N4:N17)
N19:Y19	N19	=IF(ISERROR(N18/$P$23),0,N18/$P$23)

 

[Fluff]

How about

=COUNTIFS($M$23:$M$47,$M4,$N$23:$N$47,">="&EOMONTH(N$3,-1)+1,$N$23:$N$47,"<"&EOMONTH(N$3,0)+1,$O$23:$O$47,"=Yes")

 

[Unlucky]

Thank you. That seems to work just right. I genuinely appreciate your help.

 

[Fluff]

You're welcome & thanks for the feedback.