Count the number of times multiple condition are met

**wishkey** · 04-27-2013, 07:25 AM

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!

**Cheeky Charlie** · 04-27-2013, 07:30 AM

Try
=countifs(A:A,A10,C:C,C10)

Although, as your example is a picture I can't test this.

**wishkey** · 04-27-2013, 08:02 AM

Hey,
Thanks for that. It almost works, except it doesn't account for the instance where team c played as the away team (i.e. when team c appear in column b. I've attached the workbook this time. Very grateful.