Adding top 10 numbers from 100
=SUMIF(List,""&LARGE(List,LgList),List)+(LgList-COUNTIF(List,""&LARGE(List,LgList)))*LARGE(List,L gList)
where List is the range of cells that you are evauluating
and LgList is the top X number that you want to sum.
--
John C
"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?
|