=SMALL(A:A,1)+SMALL(A:A,2)
Vaya con Dios,
Chuck, CABGx3
"jdp554" wrote:
I am familiar with the min function, but I need to add two low values in
a range.
Example, If I have a range of four values (5, 4, 6, 5), how do i write
the formula to add only the two lowest scores. In the example, the
result of the formula would need to be 9 (4 & 5). thanks
--
jdp554
------------------------------------------------------------------------
jdp554's Profile: http://www.excelforum.com/member.php...o&userid=28185
View this thread: http://www.excelforum.com/showthread...hreadid=477160