This will return the lowest number from the range A1:A10:

Entered in any cell *other than* A1:A10 -

=MIN(A1:A10)

--
Biff
Microsoft Excel MVP


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