COUNTIFS with array help

[kenderweasel]

Hi,

I am trying to create a formula that will count the number of unique IDs associated with an interaction date where each ID can have multiple interactions per date. Any ideas on how to do this with a single formula in a table?

CustID	Interaction 1	Interaction 2	Interaction 3	Interaction 4
186718317248342155	03/10/2018	NULL	NULL	NULL
186718323715048902	04/10/2018	NULL	NULL	NULL
186718334363875422	04/10/2018	04/10/2018	04/10/2018	NULL
186718335685871159	07/10/2018	NULL	NULL	NULL
186718338800604518	04/10/2018	04/10/2018	NULL	NULL
186718339338591264	05/10/2018	NULL	NULL	NULL
186718350455888328	04/10/2018	NULL	NULL	NULL
186718350530861890	03/10/2018	NULL	NULL	NULL
186718350747787245	03/10/2018	05/10/2018	05/10/2018	05/10/2018
186718350985618728	04/10/2018	NULL	NULL	NULL
186718351911846166	07/10/2018	07/10/2018	07/10/2018	NULL

<colgroup><col width="142" style="width: 107pt; mso-width-source: userset; mso-width-alt: 5193;"> <col width="111" style="width: 83pt; mso-width-source: userset; mso-width-alt: 4059;" span="4"> <tbody> </tbody>

 

[MARZIOTULLIO]

	A​	B​	C​	D​	E​	F​	G​	H​	I​	J​	K​	L​	M​
1​	CustID	Interaction 1	Interaction 2	Interaction 3	Interaction 4			COUNT	Interaction 1	Interaction 2	Interaction 3	Interaction 4
2​	186718317248342000​	3/10/2018​	NULL	NULL	NULL			2​	3/10/2018​	NULL	NULL	NULL
3​	186718323715048000​	4/10/2018​	NULL	NULL	NULL			3​	4/10/2018​	NULL	NULL	NULL
4​	186718334363875000​	4/10/2018​	4/10/2018​	4/10/2018​	NULL			1​	4/10/2018​	4/10/2018​	4/10/2018​	NULL
5​	186718335685871000​	7/10/2018​	NULL	NULL	NULL			1​	7/10/2018​	NULL	NULL	NULL
6​	186718338800604000​	4/10/2018​	4/10/2018​	NULL	NULL			1​	4/10/2018​	4/10/2018​	NULL	NULL
7​	186718339338591000​	5/10/2018​	NULL	NULL	NULL			1​	5/10/2018​	NULL	NULL	NULL
8​	186718350455888000​	4/10/2018​	NULL	NULL	NULL			1​	3/10/2018​	5/10/2018​	5/10/2018​	5/10/2018​
9​	186718350530861000​	3/10/2018​	NULL	NULL	NULL			1​	7/10/2018​	7/10/2018​	7/10/2018​	NULL
10​	186718350747787000​	3/10/2018​	5/10/2018​	5/10/2018​	5/10/2018​
11​	186718350985618000​	4/10/2018​	NULL	NULL	NULL
12​	186718351911846000​	7/10/2018​	7/10/2018​	7/10/2018​	NULL

<tbody>
</tbody>

H2=IF(ROWS($H$2:H2)<=ROWS($I$2:$I$9),SUM(IF(FREQUENCY(IF($B$2:$B$12&$C$2:$C$12&$D$2:$D$12&$E$2:$E$12=I2&J2&K2&L2,MATCH($A$2:$A$12,$A$2:$A$12,0)),ROW($A$2:$A$12)-ROW($A$2)+1),1)),"") control+shift+enter copy down