COUNTIF line varies

[JTL9161]

I have the below standings with names and averages. I have an table in alphabetical order with numbers in a row (25 columns) ranging from 1 to 5. I want to do a COUNTIF as to how many 1's 2's 3's 4's & 5's are in a row for a specific person. Problem is that names on below list will be in random order based on standing and the COUNTIF table is in alphabetical order. Need to have a COUNTIF do the count in the row of the name (ABC in this case).

Thank you,
James

Standing​	Names​	Average​	1​	2​	3​	4​	5​
1​	ABC	5.00​	0​	0​	0​	0​	1​
1​	DEF	5.00​
1​	GHI	5.00​
1​	JKL	5.00​
5​	MNO	4.00​
5​	PQR	4.00​
5​	STV	4.00​

 

[StephenCrump]

Something like this perhaps?

	A	B	C	D	E	F	G
1	ABC	3	0	1	0	2	0
2	DEF	4	4	5	3	0	0
3	GHI	5	5	1	5	1	1
4	JKL	5	0	5	5	1	0
5
6	COUNT	0	1	2	3	4	5
7	GHI	0	3	0	0	0	3
8	DEF	2	0	0	1	2	1
Sheet1

Cell Formulas
Range	Formula
B6:G6	B6	=SEQUENCE(,6,0)
B7:G8	B7	=COUNTIF(XLOOKUP(A7,A$1:A$4,B$1:G$4),B$6#)
Dynamic array formulas.

 

[JTL9161]

thanks, I'll give it a try