Sum of six columns with certain conditions using if statement

[nskatoch]

	C6​	D6​	E6​	F6​	G6​	H6​	I6​	TOTAL(Sum of Six Columns.
Max. marks	80​	80​	80​	80​	80​	80​	80​	480​
SAN	40	70	60	50	25	40	45
JOHN	30	35	40	26	40	45	22

In the above table, I want Sum of six columns out of seven with the following conditions,
IF (F6<27, SUM(C6,D6,E6,G6,H6,I6),
IF (G6<27, SUM (C6,D6,E6,F6,H6,I6)
IF (H6<27, SUM(C6,D6,E6,F6,G6,I6)
IF (I6<F6, SUM(C6,D6,E6,F6,G6,H6)
IF (I6<G6, SUM(C6,D6,E6,F6,G6,H6)
IF (I6<H6, SUM(C6,D6,E6,F6,G6,H6),
IF (I6<0, SUM(C6,D6,E6,F6,G6,H6).

I have applied the following formula, but it does not fulfil all the above conditions:

=IF(F6<27,SUM(C6,D6,E6,G6,H6,I6),IF(G6<27,SUM(C6,D6,E6,F6,H6,I6),IF(H6<27,SUM(C6,D6,E6,F6,G6,I6),IF(I6<0,SUM(C6,D6,E6,F6,G6,H6),IF(I6<F6,SUM(C6,D6,E6,F6,G6,H6),IF(I6<G6,SUM(C6,D6,E6,F6,G6,H6),IF(I6<H6,SUM(C6,D6,E6,F6,G6,H6),"")))))))

 

[nskatoch]

Or try?

=SUM(C6:I6)-MIN(C6:I6)

Thanks, dear member, both formulas do not fulfill the conditions

 

[Phuoc]

Book1
	A	B	C	D	E	F	G	H	I	J	K
6		A	80	80	80	80	80	80	80		480
7		B	40	70	60	50	25	40	45		305
8		C	30	35	40	26	40	45	22		212
9		D	66	51	71	47	55	26	21		311
10		E	44	51	52	61	19	38	18		264
Sheet1

Cell Formulas
Range	Formula
K6:K10	K6	=SUM(C6:I6)-IFERROR(INDEX(C6:I6,MATCH(1,--(C6:I6<27),0)),MIN(C6:I6))
Press CTRL+SHIFT+ENTER to enter array formulas.

 

[nskatoch]

Book1
	A	B	C	D	E	F	G	H	I	J	K
6		A	80	80	80	80	80	80	80		480
7		B	40	70	60	50	25	40	45		305
8		C	30	35	40	26	40	45	22		212
9		D	66	51	71	47	55	26	21		311
10		E	44	51	52	61	19	38	18		264
Sheet1

Cell Formulas
Range	Formula
K6:K10	K6	=SUM(C6:I6)-IFERROR(INDEX(C6:I6,MATCH(1,--(C6:I6<27),0)),MIN(C6:I6))
Press CTRL+SHIFT+ENTER to enter array formulas.

Dear member, thank you very much.