COUNTIFS Query to Sum values

[craigs85]

Hi All,
I think what I am trying to do should be doable, but i'm struggling so hoping someone might be able to help.

I have a set of columns like this:

Book1
	A	B	C	D	E	F	G
1	Season	21-22	21-22	22-23	22-23	23-24	23-24
2	Match Type	Friendly	Friendly	League	League	League	League
3	Goals	Player 1	Player 1	Player 3	Player 3	Player 3	Player 3
4			Player 1	Player 2	Player 1	Player 1
5			Player 1	Player 3
6			Player 1	Player 1
7			Player 2	Player 1
8			Player 2	Player 1
9			Player 3	Player 4
10			Player 4	Player 5
11			Player 5	Player 5
12			Payer 5
Sheet1

I then want to be able to count the number of times each Player appears under each one, and group by Season.

So player one would have 5 for 21-22, 4 for 22-23 and 1 for 23-24.

Notes that the columns will increase indefinitely so I need to factor that in as well.

I tried a COUNTIFS like this: =COUNTIFS('Tab1'!3:12,B1="21/22")

But it doesn't work. Can anyone help?

 

[Fluff]

How about

=SUMPRODUCT((B3:AB14="Player 1")*(B1:AB1="21-22"))

 

[craigs85]

Absolutely Spot on! Thank you!

 

[Fluff]

You're welcome & thanks for the feedback.