close
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: www.excelforum.com/member.php...oamp;userid=21419
View this thread: www.excelforum.com/showthread...hreadid=530544What about ties? If you don't care about ties
=SUMPRODUCT(SMALL(A1:A20,{1;2;3}))--
Regards,
Peo Sjoblom
nwexcelsolutions.com
quot;Bearkatquot; gt; wrote in message
...
gt;
全站熱搜