I have an excel list as shown below – I wanted to count the occurrence matching THREE Columns:
A B C
Practical
2/9/2019
Shift A
Practical
2/9/2019
Shift A
Practical
2/9/2019
Shift A
Practical
2/9/2019
Shift A
Practical
2/9/2019
Shift B
Practical
2/9/2019
Shift B
Practical
2/9/2019
Shift B
Theoretical
1/6/2019
Shift B
Theoretical
1/6/2019
Shift B
Theoretical
1/6/2019
Shift B
Theoretical
1/6/2019
Shift B
Theoretical
1/6/2019
Shift C
Theoretical
1/6/2019
Shift C
Theoretical
1/6/2019
Shift C
Theoretical
1/6/2019
Shift B
Theoretical
1/6/2019
Shift B
Theoretical
1/6/2019
Shift B
Practical
1/9/2019
Shift A
Practical
1/9/2019
Shift A
Practical
1/9/2019
Shift A
Practical
1/9/2019
Shift B
Practical
1/9/2019
Shift B
Need a formula to count How many "practical" for the particular "date" "shift A" .
Answer should be è On 2/9/2019 Shift A , Practical = 4
On 2/9/2019 Shift B, Practical = 3
On 1/9/2019 Shift A, Practical = 3 and so on