Formula to Count unique base on Criteria and monthly

[Lukma]

Hi Friend

Am Having issue with the formula and i really need a help with to resolve it

In Column L2 am trying to count AD-222 unique without having duplicate count, appreciate with help from any one

Thanks

countif with unique_042917.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L
1		Manger	Mus	Product	Type			Month	January			AD-222
2	01/01/2022 0:00	Manager 1	1	AD-222		0.20	0.20		Manager 1		4	#DIV/0!
3	01/01/2022 6:00	Manager 1	1	AD-222		0.20	0.20		Manager 2		2	1
4	01/01/2022 6:00	Manager 1	1	AD-222		0.20	0.20
5	01/01/2022 6:00	Manager 1	1	AD-222		0.20	0.20
6	01/01/2022 6:00	Manager 1	1	AD-222		0.20	0.20
7	01/02/2022 6:00	Manager 2	2	AD-223		0.20	0.33
8	01/02/2022 6:00	Manager 2	2	AD-223		0.20	0.33
9	01/02/2022 6:00	Manager 2	2	AD-223		0.20	0.33
10	04/01/2022 6:00	Manager 2	2	AD-222		0.20	0.50
11	04/01/2022 6:00	Manager 2	2	AD-222		0.20	0.50
12	02/01/2011 2:48	Manager 3	3	AD-224		0.20	0.20
13	02/01/2011 4:32	Manager 3	3	AD-224		0.20	0.20
14	02/01/2011 6:16	Manager 3	3	AD-224		0.20	0.20
15	02/01/2011 6:16	Manager 3	3	AD-224		0.20	0.20
16	01/01/2011 5:33	Manager 3	3	AD-224		0.20	0.20
17	04/02/2022 6:00	Manager 2	4	AD-223		0.25	0.25
18	04/02/2022 6:00	Manager 2	4	AD-223		0.25	0.25
19	04/02/2022 6:00	Manager 2	4	AD-223		0.25	0.25
20	04/02/2022 6:00	Manager 2	4	AD-223		0.25	0.25
21	05/01/2022 6:00	Manager 1	5	AD-222		0.50	0.50
22	05/01/2022 6:00	Manager 1	5	AD-222		0.50	0.50
23	05/01/2022 6:00	Manager 1	6	AD-222		1.00	1.00
24	05/01/2022 6:00	Manager 1	7	AD-222		1.00	1.00
Sheet1

Cell Formulas
Range	Formula
F2:F24	F2	=1/COUNTIFS($C$2:$C$24,C2)
G2:G24	G2	=1/COUNTIFS($C$2:$C$24,C2,$D$2:$D$24,D2)
K2	K2	=SUMPRODUCT((L1=$D$2:$D$24)*1,1/COUNTIFS($C$2:$C$24,$C$2:$C$24))
L2	L2	=SUMPRODUCT((I2=$B$2:$B$24)*1,($D$2:$D$24=L$1)*1,1/COUNTIFS($C$2:$C$24,$C$2:$C$24,$D$2:$D$24,$D$2:$D$24,A2:A24,I1))
K3	K3	=SUMPRODUCT((I3=$B$2:$B$24)*1,$F$2:$F$24)
L3	L3	=SUMPRODUCT((I3=$B$2:$B$24)*1,($D$2:$D$24=L$1)*1,$G$2:$G$24)

 

[AhoyNC]

Maybe something like this?
This is an array function and must be entered with CTRL-SHIFT-ENTER

Book1
	A	B	C	D	E	F	G	H	I	J	K	L
1		Manger	Mus	Product	Type			Month	January			AD-222
2	1/1/22 0:00	Manager 1	1	AD-222		0.2	0.2		Manager 1		4.4	4
3	1/1/22 6:00	Manager 1	1	AD-222		0.2	0.2		Manager 2		2	1
4	1/1/22 6:00	Manager 1	1	AD-222		0.2	0.2		Manager 3		1	0
5	1/1/22 6:00	Manager 1	1	AD-222		0.2	0.2
6	1/1/22 6:00	Manager 1	1	AD-222		0.2	0.2
7	2/1/22 6:00	Manager 2	2	AD-223		0.2	0.33333
8	2/1/22 6:00	Manager 2	2	AD-223		0.2	0.33333
9	2/1/22 6:00	Manager 2	2	AD-223		0.2	0.33333
10	1/4/22 6:00	Manager 2	2	AD-222		0.2	0.5
11	1/4/22 6:00	Manager 2	2	AD-222		0.2	0.5
12	1/2/11 2:48	Manager 3	3	AD-224		0.2	0.2
13	1/2/11 4:32	Manager 3	3	AD-224		0.2	0.2
14	1/2/11 6:16	Manager 3	3	AD-224		0.2	0.2
15	1/2/11 6:16	Manager 3	3	AD-224		0.2	0.2
16	1/1/11 5:33	Manager 3	3	AD-224		0.2	0.2
17	2/4/22 6:00	Manager 2	4	AD-223		0.25	0.25
18	2/4/22 6:00	Manager 2	4	AD-223		0.25	0.25
19	2/4/22 6:00	Manager 2	4	AD-223		0.25	0.25
20	2/4/22 6:00	Manager 2	4	AD-223		0.25	0.25
21	1/5/22 6:00	Manager 1	5	AD-222		0.5	0.5
22	1/5/22 6:00	Manager 1	5	AD-222		0.5	0.5
23	1/5/22 6:00	Manager 1	6	AD-222		1	1
24	1/5/22 6:00	Manager 1	7	AD-222		1	1
Sheet1

Cell Formulas
Range	Formula
F2:F24	F2	=1/COUNTIFS($C$2:$C$24,C2)
G2:G24	G2	=1/COUNTIFS($C$2:$C$24,C2,$D$2:$D$24,D2)
K2	K2	=SUMPRODUCT((L1=$D$2:$D$24)*1,1/COUNTIFS($C$2:$C$24,$C$2:$C$24))
L2:L4	L2	=SUM(IF(FREQUENCY(IF(B$2:B$24=$I2,IF(MONTH($A$2:$A$24)=MONTH($I$1),IF($D$2:$D$24=$L$1,MATCH($D$2:$D$24&"/"&$C$2:$C$24,$D$2:$D$24&"/"&$C$2:$C$24,0)))),ROW($D$2:$D$24)-ROW($D$2)+1),1))
K3:K4	K3	=SUMPRODUCT((I3=$B$2:$B$24)*1,$F$2:$F$24)
Press CTRL+SHIFT+ENTER to enter array formulas.

 

[Lukma]

Thanks AhoyNC

it works, and am grateful , however got it at end

​