heretolearnexcel
Board Regular
- Joined
- Jan 22, 2019
- Messages
- 58
- Office Version
- 365
- Platform
- Windows
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") |