title: excel sum the 25 highest numbers
body: <p>i have tried to find a formula that will look into the sheet1 colum D where there are allot of numbers. some friends and i are having a competition and we want to sum the points with the top 25 points for each contender.</p>
  <p>if we use =SUM(Sheet1!D2:D10000)  then all the numbers are summed but wo only want the top 25 numbers. what formula to add?</p>