Adding top 10 numbers from 100
Don't see why the Indirect is needed - seems to work without it.... But
please enlighten me...
--
"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
|