Adding Multiple low values

  • Thread starter Thread starter jdp554
  • Start date Start date
J

jdp554

I am familiar with the min function, but I need to add two low values i
a range.
Example, If I have a range of four values (5, 4, 6, 5), how do i writ
the formula to add only the two lowest scores. In the example, th
result of the formula would need to be 9 (4 & 5). thank
 
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
 
Back
Top