=LARGE(A1:B100,1)+LARGE(A1:B100,2)+LARGE(A1:B100,3 )+LARGE(A1:B100,4)+LARGE(A1:B100,5)+LARGE(A1:B100, 6)+LARGE(A1:B100,7)+LARGE(A1:B100,8)+LARGE(A1:B100 ,9)+LARGE(A1:B100,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?