ExcelBanter - Sum of minimum values in a Range.

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Sum of minimum values in a Range. (https://www.excelbanter.com/excel-discussion-misc-queries/147269-sum-minimum-values-range.html)

BiggDC1

Sum of minimum values in a Range.

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.

Gary''s Student

Sum of minimum values in a Range.

=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.

Peo Sjoblom

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.

All times are GMT +1. The time now is 02:38 AM.