Hey, I forgot to mention that the spreadsheet has a total of 500 numbers of
which the know numbers relevant for the top 10 sum result are 100. There are
thus many other numbers some small some large in same spreadsheet which
should be excluded from the formula. The numbers are in no row order or
column order. I know the cell numbers where the relevant numbers are located
though.

"Dave Peterson" wrote:

One mo

=SUMPRODUCT(LARGE(A1:H100,ROW(INDIRECT("1:10"))))

Frustrated wrote:

How do I add the top 10 numbers out of 100 numbers that are not in a row or
column but scattered throughout a spreadsheet. For instance, the first number
might be in cell a2, second in cell ba15, and so on.

How would I write the formula to sum the top something numbers?

--

Dave Peterson