Sum of minimum values in a Range.
Or
=SUM(SMALL(A1:A100,{1,2}))
--
Regards,
Peo Sjoblom
"Gary''s Student" wrote in message
...
=SMALL(A1:A100,1)+SMALL(A1:A100,2)
--
Gary''s Student - gsnu200731
"BiggDC1" wrote:
I have range of values that I need to extract the sum of the two lowest
values. Kinda a newbie and dont know how to string together functions
for
this value. Any help would be appreciated.
|