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;

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()