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!!!