|
Posted to microsoft.public.excel.programming
|
|
|
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
|