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

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

Thanks,

Howdy


---
Message posted from http://www.ExcelForum.com/

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

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



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

Thanks,

Howdy


---
Message posted from http://www.ExcelForum.com/

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

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 " wrote in message
...
I am attempting to arrive at the 10 lowest numbers out of 20 and sum
those 10. Any suggestions???

Thanks,

Howdy


---
Message posted from http://www.ExcelForum.com/

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

Howdy < wrote:

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,
--
Beto
Reply: Erase between the dot (inclusive) and the @.
Responder: Borra la frase obvia y el punto previo.

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

Niek Otten wrote:
*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 " wrote in message
...
I am attempting to arrive at the 10 lowest numbers out of 20 an
sum
those 10. Any suggestions???

Thanks,

Howdy


---
Message posted from http://www.ExcelForum.com/


--
Message posted from http://www.ExcelForum.com