How to get the 10 lowest numbers out of 20 in Excel

[Howdy]

I am attempting to arrive at the 10 lowest numbers out of 20 and sum
those 10. Any suggestions???

Thanks,

Howdy

 

[Chip Pearson]

Use the following array formula:

=SUM(SMALL(A1:A20,ROW(INDIRECT("1:10"))))

Since this is an array formula, you must press Ctrl+Shift+Enter
rather than just Enter when you first enter the formula and
whenever you edit it later. If you do this properly, Excel will
display the formula enclosed in curly braces {}.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[Niek Otten]

Hi Howdy,

=SMALL($A$1:$A$20,1)
=SMALL($A$1:$A$20,2),

etc, and then SUM those 10 formulas

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

 

[Beto]

I am attempting to arrive at the 10 lowest numbers out of 20 and sum
those 10. Any suggestions???

{=SUM(((A1:A20)<MEDIAN(A1:A20))*A1:A20)}

Assuming of course the numbers are in A1:A20
Notice this is a formula array which must be entered with
Cctrl+Shift+Enter, do not put the brackets, just type it and press
Ctrl+Shift+Enter.

Regards,

 

[Howdy]

*Hi Howdy,

=SMALL($A$1:$A$20,1)
=SMALL($A$1:$A$20,2),

etc, and then SUM those 10 formulas

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel