=MIN(A1:A10)
--
Gary''s Student - gsnu200901


"Meejung" wrote:

Is there a formula which will search for the lowest number in a range and
will put that value into another cell which can then be auto summed?

Thanks,
Shelli