View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Frustrated Frustrated is offline
external usenet poster
 
Posts: 55
Default Adding top 10 numbers from 100

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?