Column A
1
2
3
4
5
6
7
8
9
10
11

Column B
1
2
3
4
5
6
7

Column C
1
2
3
4
5
6
7

I need to count the occurences of the values 1, 2, 3, 4, 6 in Columns B & C if the criteria in Column A is satisfied which is Column A values must be either 1, 2, 3, 4, 7 or 11.

What is the most efficient way to do this?

Thank you