Extract a list of names and averages from a table but observing certain attributes.

[edge37]

Hi, I'm trying to extract or filter, from the included table, a list of students from A2:A7 that have an average of >=91, from K2:K7, but only if the student's notes (from B2:J7) are >=80, meaning, If the student has an average of 92, but one of his HW grades is 75, then she will not be in the list. I want to put that list in the table from M2:N7, Names in M column and their averages in N column.

Can you help me, please?

Thanks

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1	NAME	HW1	HW2	HW3	HW4	HW5	HW6	HW7	HW8	HW9	AVERAGE		OUTSTANDING PERFORMANCE
2	Camila Alessandra Diaz Mayes	100	100	63	81	92	100	97	100	100	92.56
3	Ericka Sofia Castellanos Pineda	76	85	95	70	78	79	88	93	95	84.33
4	Eva Patricia Rodríguez Escoto	98	83	100	100	72	80	100	100	100	92.56
5	Hanna Valeria Mejía Pagoada	87	100	66	82	89	100	99	100	100	91.44
6	Julia Valeria Barahona Hernández	100	100	91	100	100	100	100	100	100	99.00
7	Lia Alessandra Chavez Valenzuela	100	79	90	82	97	95	100	93	85	91.22
Sheet1

Cell Formulas
Range	Formula
K2:K7	K2	=AVERAGE(B2:J2)

 

[edge37]

How about

=LET(a,B2:J7,c,COLUMNS(a),f,FILTER(A2:K7,(K2:K7>=91)*(MMULT(--(a>=81),SEQUENCE(c,,,0))=c)*(MMULT(--(a>=91),SEQUENCE(c,,,0))<>c)),INDEX(f,SEQUENCE(ROWS(f)),{1,11}))

And you did it again, Sr.

Many thanks to you!... again

 

[Fluff]

My pleasure.