On Mon, 21 Jul 2008 17:04:22 GMT, Lars-Åke Aspelin
wrote:

On Mon, 21 Jul 2008 04:16:01 -0700, 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?


Try this formula
Note that it is an array formula and has to be confirmed with
CTRL+SHIFT+ENTER rather than just ENTER

=SUM(LARGE((myrange)*(mymap),ROW(1:10)))

myrange is a named range big enough to cover all interesting data
mymap is a named range with the same size but perhaps on another
sheet.

In mymap you mark with 1 each of the 100 (scattered) cells that
corresponds to the 100 numbers that you are interested in. the other
cells should remain blank.

The formula will result in the sum of the top 10 of these numbers.

WARNING: if the layout of the sheet with myrange, you have to update
mymap as well.

Hope this helps / Lars-Åke



if you change the layout.... I meant, but missed out two words.