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

Hi

Try the SMALL() function

=SUM(SMALL(A1:A4,{1,2}))
The figures inside the curly braces {1,2) tell the formula to take the 1st
(smallest) and the 2nd.


Regards

Roger Govier


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

=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