Dave,

Your absolutely correct, because I had an array of numbers it gave me an
(incorrect) mindset the formula was an array.

Thanks for the correction.

Mike

"Dave Peterson" wrote:

I didn't have to array enter this one.

Mike H wrote:

Try

=SUM(LARGE(A1:H100, {1,2,3,4,5,6,7,8,9,10}))

Which is an Array so enter with Ctrl+Shuft+Enter

Mike

"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