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

[Ron Coderre]

Try this:

For numbers in A1:A10

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

Does that help?

Regards,
Ron

 

[Peo Sjoblom]

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

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


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com