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)


"PEA" wrote in message
...
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