If you are wanting the sum of the 10 lowest values in a range:
=SUM(SMALL(A1:A100,ROW(1:10)))
This is an **array** formula, you must CTRL+SHIFT+ENTER to enter the
formula. Was confused by what you meant 1-20, 2-21, 3-22, etc. So if this
formula doesn't do what you asked, please clarify.
--
** John C **
Please remember, if your question is answered, to check the YES box below.
It helps everyone.


"edwgolz" wrote:

I have an array of data in which I'd like to return the sum of the lowest 10
numbers without having to sort. Specifically, I would like to find the lowest
10 cells 1-20, 2-21, 3-22 etc in a list of 100.
Thanks