Sum 2 cells one cell to the left of max and min percentage in a row

[Excelaron]

[TABLE="width: 1119"]
<tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[TD]G[/TD]
[TD]H[/TD]
[TD]I[/TD]
[TD]J[/TD]
[TD]K[/TD]
[TD]L[/TD]
[TD]M[/TD]
[TD][/TD]
[TD="align: right"]14.9%[/TD]
[TD]Max[/TD]
[/TR]
[TR]
[TD]8.9%[/TD]
[TD]187633[/TD]
[TD]10.8%[/TD]
[TD]236717[/TD]
[TD]9.7%[/TD]
[TD]208606[/TD]
[TD]10.8%[/TD]
[TD]156942[/TD]
[TD]7.5%[/TD]
[TD]149744[/TD]
[TD]6.1%[/TD]
[TD]258276[/TD]
[TD]14.9%[/TD]
[TD][/TD]
[TD="align: right"]6.1%[/TD]
[TD]Min[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 11"]Find the cell with the max and min percentages then location cell address one cell to the left (cells L2 and J2) and sum those 2 cells (408020)[/TD]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody><colgroup><col span="13"><col><col><col></colgroup>[/TABLE]

 

[AlphaFrog]

<br />

Book1
	O	P
1	14.90%	Max
2	6.10%	Min
3
4	408020	Sum
Sheet1

Cell Formulas
Range	Formula
O1	=MAX(A2,C2,E2,G2,I2,K2,M2)
O2	=MIN(A2,C2,E2,G2,I2,K2,M2)
O4	=INDEX(A2:M2,MATCH(O1,A2:M2,0)-1)+INDEX(A2:M2,MATCH(O2,A2:M2,0)-1)

 

[vlady]

hello
maybe like this???

=SUM(OFFSET(A2,,MATCH(MAX(IF(A2:M2<=100%,A2:M2)),A2:M2,0)-2),OFFSET(A2,,MATCH(MIN(IF(A2:M2<=100%,A2:M2)),A2:M2,0)-2))

or if you have the formula for min(Q2) and max(Q1)
maybe

=OFFSET(A2,,MATCH(Q1,A2:M2,0)-2)
=OFFSET(A2,,MATCH(Q2,A2:M2,0)-2)
then just combine the two in the the sum function


Edit: opps didn't refresh window.. Sorry for that Alpha.