How do you add the three lowest numbers in a column?
 

How do you add the three lowest numbers in a column?
 

Try this:

For numbers in A1:A10

A11: =SUM(SMALL(A1:A10,{1,2,3}))

Does that help?

Regards,
Ron


--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419
View this thread: http://www.excelforum.com/showthread...hreadid=530544

How do you add the three lowest numbers in a column?
 

What about ties? If you don't care about ties

=SUMPRODUCT(SMALL(A1:A20,{1;2;3}))


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com



"Bearkat" wrote in message
...