Count when two people worked on the same day.

[heretolearnexcel]

I have the following data table and would like to know how many times two employees worked on the same. I tried a countifs formula but it doesn't work. Could anyone help me find a solution?

Cirugias.xlsx
	A	B	C	D	E
1	Technician	Type of Surgery	Shift	Date
2	Rose	Apendicectomia	V	10/22/2020	0
3	Mike	Colecistectomia	M/V	10/23/2020	0
4	Rose	Hemicolectomia	M	10/24/2020	0
5	Mike	Quiste de ovario	M	10/26/2020	0
6	Rose	Lap. Exploradora	M	10/26/2020	0
7	Mike	Lap. Exploradora	M/V	10/26/2020	0
8	Rose	Lap. Exploradora	M	10/27/2020	0
9	Mike	Lap. Exploradora	M	10/28/2020	0
10	Mike	Lap. Exploradora	V	10/30/2020	0
11	Rose	Histerectomia	V	10/30/2020	0
12	Rose	Histerectomia	V	10/30/2020	0
13	Mike	Colecistectomia	M/V	10/31/2020	0
14	Rose	Colecistectomia	M	11/4/2020	0
15	Mike	Histerectomia	M	11/7/2020	0
16	Rose	Quiste de ovario	M	9-Nov	0
17	Rose	Colecistectomia	M	11/11/2020	0
18	Mike	Histerectomia	M	11/11/2020	0
19	Rose	Lap. Exploradora	M/V	11/12/2020	0
20	Rose	Lap. Exploradora	M/V	11/18/2020	0
21	Mike	Apendicectomia	V	11/18/2020	0
22	Mike	Histerectomia	M	11/19/2020	0
23	Rose	Lap. Exploradora	M	11/20/2020	0
24	Rose	Colecistectomia	M	11/20/2020	0
25	Rose	Apendicectomia	V	11/24/2020	0
26	Mike	Histerectomia	M	11/25/2020	0
27	Mike	Miomectomia	M/V	11/25/2020	0
28	Rose	Colecistectomia	M/V	11/25/2020	0
29	Rose	Histerectomia	M/v	11/30/2020	0
30	Mike	Hernia	V	12/3/2020	0
31	Rose	Colecistectomia	V	12/5/2020	0
32	Mike	Hernia	M	12/9/2020	0
33	Mike	Colecistectomia	M	12/9/2020	0
34	Rose	Apendicectomia	V	12/13/2020	0
35	Rose	Hernia	V	12/16/2020	0
36	Mike	Hernia	M	12/17/2020	0
37	Mike	Colecistectomia	V	12/18/2020	0
38	Rose	Apendicectomia	V	12/19/2020	0
39	Mike	Miomectomia	M/V	12/21/2020	0
40	Rose	Lap. Exploradora	V	1/1/2021	0
41	Rose	Colecistectomia	M	1/16/2021	0
42	Mike	Apendicectomia	V	1/19/2021	0
43	Rose	Colecistectomia	M	1/20/2021	0
44	Rose	Apendicectomia	V	1/20/2021	0
45	Mike	Colecistectomia	V	1/23/2021	0
46	Rose	Apendicectomia	M	1/24/2021	0
47	Mike	Apendicectomia	V	1/25/2021	0
48	Rose	Colecistectomia	V	1/28/2021	0
49	Mike	Apendicectomia	V	1/30/2021	0
50	Mike	Reseccion instetinal	M	1/30/2021	0
51	Rose	Colecistectomia	V	2/1/2021	0
52	Mike	Lap. Exploradora	V	2/4/2021	0
53	Mike	Colecistectomia	M/V	2/12/2021	0
54	Rose	Histerectomia	M/V	2/19/2021	0
55	Mike	Colecistectomia	V	2/19/2021	0
56	Mike	Histerectomia	M	2/20/2021	0
57	Mike	Colecistectomia	V	2/22/2021	0
58	Rose	Colecistectomia	V	2/23/2021	0
59	Rose	Lap. Exploradora	V	2/24/2021	0
60	Rose	Lap. Exploradora	M	1/26/2021	0
61	Mike	Apendicectomia	V	3/1/2021	0
Hoja1

Cell Formulas
Range	Formula
E2:E61	E2	=COUNTIFS($D$2:$D$61,D2,$A$2:$A$61,"Rose",$A$2:$A$61,"Mike")

 

[MarkTHU]

I think of Transpose (Unique(Filter (All the names, Condition = Date Analysed)) and then you concatenate them and remove duplicates (or use Unique again) - not a single step solution, nor super elegant, I guess, but might do the work?

I've never used Concat function, but you probably can join them in one cell too

 

[MarkTHU]

I've never used Concat function, but you probably can join them in one cell too

And then you use Count (Unique) and that's it? Sorry I've spilled into 3 messages lol newbie here