Spreadsheet formula: lowest 100 values in a range

Posted by Justin Lawrence on Super User See other posts from Super User or by Justin Lawrence
Published on 2010-04-09T12:42:07Z Indexed on 2010/04/09 12:43 UTC
Read the original article Hit count: 480

Is there any way I could sum up the lowest 100 values within a range?

I know that min() would give you the lowest value but i need something to return the 100 lowest values.

I just used 100 hypothetically to make it easier to understand what I'm trying to achieve.

I can use any of the following spreadsheet apps: Openoffice.org, Excel or Google Spreadsheets -- whichever works.

Thanks a lot!!!

© Super User or respective owner

Related posts about openoffice.org

Related posts about excel