How do I find the two lowest values in a range?

[Ola]

Try
=SMALL(A1:A10,1)
=SMALL(A1:A10,2)
and if you want the sum
=SUM(SMALL(A1:A10,{1,2}))

but if you want the 2 lowest Unique values, the formula becomes is a little
bit more complicated. Let us know if that's the case.

Ola

 

[Myrna Larson]

Look at the MIN and SMALL functions