The SMALL formula does not seem to work if there are negative values present.
For example, if the data we

-5, -3, 0, 2, 4

the minimum should be -5
--
Gary''s Student - gsnu200854


"T. Valko" wrote:

={MIN(IF(R2:AA20,R2:AA2))}

One way, but the difference in calc speed is insignificant.

=SMALL(R2:AA2,COUNTIF(R2:AA2,0)+1)

Also note that with the array formula if there are no numbers in the range
that meet the condition the result will be 0. With the SMALL version, you'll
get a #NUM! error.

--
Biff
Microsoft Excel MVP


"art" wrote in message
...
Hello:

I have a formula to calculate the Min value of a range that has includes
zero values, which the min formula ignors the zero valus. However, it is
an
array function which slows down my spreadsheet, since I have this array
formula on a long list. Is there a way to calculate the min of a range
which
has also some zero values without an array function?

The formula I use now is as follows:

={MIN(IF(R2:AA20,R2:AA2))}

Thanks.

Art