Hi guys, new here but needing a little help. I'm compiling a spreadsheet with information from a local baseball league. I'm trying to create two columns which give the number of times the home and away teams have played at the venue. My spreadsheet looks as follows:

Table.png

What I would like is for column D to show how many times the home team has played at the given venue. Specifically in D10, how many times has team c played at venue y (2). D11=number of times team b has played at venue z (3).

Any help would be greatly appreciated. I am at my wits end and have all but given up on ever figuring out a solution!