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

  • Thread starter Thread starter Howdy
  • Start date Start date
H

Howdy

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

Thanks,

Howdy
 
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
 
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
 
Howdy said:
I am attempting to arrive at the 10 lowest numbers out of 20 and sum
those 10. Any suggestions???
Click to expand...

{=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,
 
Back
Top