I am trying to determine a formula for this
DATA
A B C D
1 Team 1 Team 2 Ump 1 Ump2
2 Hawks Districts Bert Frog
3 Liston Wirrulla Shag Hassy
4 United Centrals Bucky Gus
5 Hawks Centrals Bucky Frog
6 Liston United Hass Shag
7 Districts Wirrulla Gus Bert

CALCULATION Times that Umpire has umpired a specific club
8 Wirrulla Centrals United Liston
9 Shag 1 0 1 2
10 Bert 1 0 0 0

My problem is working the calculation in B9 / C9 / B10 / C10 etc

So for example I want to know how many times Shag (who could be named
anywhere in the range C2:D7) has umpired Liston (who could be named anywhere
in the range A2:B7)