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

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

"T. Valko" wrote:

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


Thanks to both of you for the very quick response. This is exactly what I was looking for.

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Meejung" wrote in message
...


"T. Valko" wrote:

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


Thanks to both of you for the very quick response. This is exactly what
I was looking for.

I got that one to work. Is is now possible to find the next lowest number?

Thanks,
Shelli

"T. Valko" wrote:

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Meejung" wrote in message
...


"T. Valko" wrote:

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


Thanks to both of you for the very quick response. This is exactly what
I was looking for.

If your real question is how to find the nth smallest value in a range, then
don't use the MIN function, use the SMALL function instead.

This is identical to the MIN function...
=SMALL(A1:A7,1)

This finds the 2nd smallest value in the range...
=SMALL(A1:A7,2)

The first argument is the range to search and the second argument is which
smallest number to find. There is a corresponding LARGE function which works
for the nth largest value in a range.

--
Rick (MVP - Excel)


"Meejung" wrote in message
...
I got that one to work. Is is now possible to find the next lowest number?

Thanks,
Shelli

"T. Valko" wrote:

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Meejung" wrote in message
...


"T. Valko" wrote:

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


Thanks to both of you for the very quick response. This is exactly
what
I was looking for.

=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