Adding Multiple low values
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
|