View Single Post
  #3   Report Post  
CLR
 
Posts: n/a
Default Adding Multiple low values

=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