INDEX, MATCH, COUNTIF, SUMIF, SUMPRODUCT

[Unlucky]

I cannot get the formula to count the number of occurrences with three criteria. I've tried COUNTIFS, SUMIFS, SUMPRODUCT, and INDEX & MATCH, but without satisfactory results. The object is to count the number of occurrences each month for DD250 on each program.

This is only a portion of the actual table, but the concept is discernable.

PRACTICE TABLES.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P
1	LAST MONTH		Tuesday, March 1, 2022					LAST MONTH		March			DATE	DATE	PROGRAM	JOB
2	THIS MONTH		Wednesday, April 20, 2022					THIS MONTH		April			Jan-22	Jan-22	BFV	DD250
3	NEXT MONTH		Sunday, May 1, 2022					NEXT MONTH		May			Jan-22	Jan-22	AMPV	Top Water Rechecks
4													Jan-22	Jan-22	BFV	FORM 2408
5	YEAR	ACV	AMPV	BFV	HERCULES	PIM		MONTH	YEAR		DD250		Jan-22	Jan-22	HERCULES	Drive Rechecks
6	Jan-2022	0	0	0	0	0		Jan	2022		18		Jan-22	Jan-22	BFV	DD250
7	Feb-2022	0	0	0	0	0		Feb	2023				Jan-22	Jan-22	PIM	DD250
8	Mar-2022	0	0	0	0	0		Mar	2024				Jan-22	Jan-22	ACV	DD250
9	Apr-2022	0	0	0	0	0		Apr	2025				Jan-22	Jan-22	PIM	SRP/NSRP
10	May-2022	0	0	0	0	0		May	2026				Jan-22	Jan-22	ACV	NCR
11	Jun-2022	0	0	0	0	0		Jun	2027				Jan-22	Jan-22	AMPV	NCR
12	Jul-2022	0	0	0	0	0		Jul	2028				Jan-22	Jan-22	AMPV	NCR
13	Aug-2022	0	0	0	0	0		Aug	2029				Feb-22	Feb-22	PIM	DD250
14	Sep-2022	0	0	0	0	0		Sep	2030				Feb-22	Feb-22	AMPV	NATO
15	Oct-2022	0	0	0	0	0		Oct	2031				Feb-22	Feb-22	AMPV	Steering
16	Nov-2022	0	0	0	0	0		Nov	2032				Feb-22	Feb-22	AMPV	Final
17	Dec-2022	0	0	0	0	0		Dec	2033				Feb-22	Feb-22	BFV	Top water
18	Jan-2023	0	0	0	0	0			2034				Mar-22	Mar-22	PIM	DD250
19	Feb-2023	0	0	0	0	0			2035				Mar-22	Mar-22	ACV	DD250
20	Mar-2023	0	0	0	0	0			2036				Mar-22	Mar-22	PIM	DD250
21	Apr-2023	0	0	0	0	0			2037				Apr-22	Apr-22	PIM	Steering
22	May-2023	0	0	0	0	0			2038				May-22	May-22	PIM	RFV
23	Jun-2023	0	0	0	0	0							May-22	May-22	PIM	RFV
24	Jul-2023	0	0	0	0	0							May-22	May-22	AMPV	Top Water Rechecks
25	Aug-2023	0	0	0	0	0							May-22	May-22	AMPV	Drive
26	Sep-2023	0	0	0	0	0							May-22	May-22	BFV	DD250
27	Oct-2023	0	0	0	0	0							May-22	May-22	BFV	DD250
28	Nov-2023	0	0	0	0	0							May-22	May-22	BFV	Roll Off
29	Dec-2023	0	0	0	0	0							Jul-22	Jul-22	BFV	DD250
30													Jul-22	Jul-22	ACV	Final
31													Aug-22	Aug-22	BFV	DD250
32													Aug-22	Aug-22	BFV	RFV
33													Aug-22	Aug-22	AMPV	Steering
34													Aug-22	Aug-22	ACV	Garage ATI
35													Sep-22	Sep-22	AMPV	Steering
36													Sep-22	Sep-22	AMPV	Drive Rechecks
37													Sep-22	Sep-22	BFV	Drive Rechecks
38													Sep-22	Sep-22	ACV	Garage ATI
39													Sep-22	Sep-22	PIM	Shipping 2408-9
40													Sep-22	Sep-22	PIM	Shipping 2408-9
41													Sep-22	Sep-22	HERCULES	Steering & Shifter
42													Sep-22	Sep-22	BFV	Packaging
43													Sep-22	Sep-22	BFV	DD250
44													Oct-22	Oct-22	BFV	Packaging
45													Oct-22	Oct-22	BFV	DD250
46													Oct-22	Oct-22	BFV	DD250
47													Oct-22	Oct-22	BFV	Packaging
48													Nov-22	Nov-22	BFV	DD250
49													Dec-22	Dec-22	ACV	(CSI) Steering torque
50													Dec-22	Dec-22	BFV	DD250
51													Dec-22	Dec-22	AMPV	DD250
52													Dec-22	Dec-22	PIM	Cab Final
Sheet1

Cell Formulas
Range	Formula
N2:N52	N2	=TEXT($M2,"MMM-YY")
C1	C1	=DATE(YEAR($C$2),MONTH($C$2)-1,1)
C2	C2	=TODAY()
C3	C3	=DATE(YEAR($C$2),MONTH($C$2)+1,1)
J1	J1	=TEXT($C$1,"MMMM")
J2	J2	=TEXT($C$2,"MMMM")
J3	J3	=TEXT($C$3,"MMMM")
M3:M12	M3	='[Quality Workload tracker 2022 v2.xlsx]WLT'!$A3
O3:O52	O3	='[Quality Workload tracker 2022 v2.xlsx]WLT'!$X3
P52,P49,P47,P44,P32:P42,P30,P28,P21:P25,P14:P17,P9:P12,P3:P5	P3	='[Quality Workload tracker 2022 v2.xlsx]WLT'!$AB3
A6:A17	A6	=$H6&"-"&$I$6
B6:F29	B6	=COUNTIFS($N$2:$N$52,$A6,$O$2:$O$52,B$5,$P$2:$P$52,$K$5)
A18:A29	A18	=$H6&"-"&$I$7
K6	K6	=COUNTIF($P$2:$P$52,$K$5)

 

[Fluff]

As you have cells that are looking at a different workbook I had to copy values only & your formula worked.

+Fluff 1.xlsm
	A	B	C	D	E	F	G
1	LAST MONTH		01/03/2022
2	THIS MONTH		20/04/2022
3	NEXT MONTH		01/05/2022
4
5	YEAR	ACV	AMPV	BFV	HERCULES	PIM
6	Jan-2022	1	0	2	0	1
7	Feb-2022	0	0	0	0	1
8	Mar-2022	1	0	0	0	2
9	Apr-2022	0	0	0	0	0
10	May-2022	0	0	2	0	0
11	Jun-2022	0	0	0	0	0
12	Jul-2022	0	0	1	0	0
13	Aug-2022	0	0	1	0	0
14	Sep-2022	0	0	1	0	0
15	Oct-2022	0	0	2	0	0
16	Nov-2022	0	0	1	0	0
17	Dec-2022	0	1	1	0	0
18	Jan-2023	0	0	0	0	0
19	Feb-2023	0	0	0	0	0
20	Mar-2023	0	0	0	0	0
21	Apr-2023	0	0	0	0	0
22	May-2023	0	0	0	0	0
23	Jun-2023	0	0	0	0	0
24	Jul-2023	0	0	0	0	0
25	Aug-2023	0	0	0	0	0
26	Sep-2023	0	0	0	0	0
27	Oct-2023	0	0	0	0	0
28	Nov-2023	0	0	0	0	0
29	Dec-2023	0	0	0	0	0
Main

Cell Formulas
Range	Formula
B6:F29	B6	=COUNTIFS($N$2:$N$52,$A6,$O$2:$O$52,B$5,$P$2:$P$52,$K$5)

Therefore it's probably something to do with the data, or maybe you have circular references somewhere.

 

[Unlucky]

Thank you!

 

[Fluff]

You're welcome.