Average of the minimum+50 in a row

[Guest]

I have rows f figurs
How does I creat a function where I want the average of the minimun+50.
I use an array where I have 200 columns an 7000 rows.
I want a function which invastigates row by row for minimum and then
calculate the average of the cells, in the row, which contain figures min+50.
Kind Regards
PEA

 

[Bob Phillips]

Not quite sure, but here is a shot at what I think that you mean

=AVERAGE(IF(A20:I20>=MIN(A20:I20)+50,A20:I20))

as an array formula, so commit with Ctrl-Shift-Enter

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Guest]

He bob
It will not work, but what I mean is, in the calculation the average I do
not want to use cells where the cell value is 50 higher than the minimun
value
ex
1001 1003 1002 1003 1080
Her I do not want to use 1080 in the average
regards

 

[Bob Phillips]

Okay,

here is an alternative. I have also added another test to ignore blanks

=AVERAGE(IF((A20:I20<=MIN(A20:I20)+50)*(A20:I20<>""),A20:I20))

still an array formula, so commit with Ctrl-Shift-Enter

--

HTH

RP
(remove nothere from the email address if mailing direct)