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:
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?
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?