Count Formula With Variable

[carlclements]

Hi.

I have a table of football player data that is used for a summary table of matches played, average minutes per match and goals for each player.
Column B lists the players
Columns C - AC is data depending on the row:
- row 1 is either T1 or T2 (T = Tier)
- row 2 is W1 - W26 (W = Week)
- row 3 onwards are the number of minutes played by the players in column B

To count the number of matches played for the first player in row 3, I'm using =COUNTA(C3:AC3).

How do adjust this formula to only count matches played when T1 is populated in row 1 of the columns?

For example, with the below data, my count of matches played for Jimena is 3 (mins played in W1, W2 and W3 but not W4). But I want to count only the matches when T1 was in row 1.

T1	T2	T2	T2
W1	W2	W3	W4
Jimena	80	80	80
Schyler	80

Thanks

 

[dermie_72]

Im assuming your table is not accurate and has become misaligned in the paste, T1 and W1 should be one cell to the right??? If so you could try this formula:

=COUNTIFS(C3:AC3,"<>""",C$1:AC$1,"T1")

 

[carlclements]

Yes. the table did misalign when I posted it, apologies. Trying again now with the full row.

I need the formula to return 8, which is a count of cells containing numbers when T1 is in row 1 (highlighted yellow). The countifs formula suggested above returns 12

 

[dermie_72]

try this one instead:

=COUNTIFS(C3:AC3,">1",C$1:AC$1,"T1")

 

[carlclements]

that worked. thanks