Add top numbers

[Frustrated]

How do you add the top 20 numbers from a list of 500 numbers in a row?

 

[M Kan]

=SUMPRODUCT(--(RANK(list_of_values,list_of_values,0)<=20),list_of_values)

 

[John C]

This formula will break if the 20th largest value has duplicates.
Try instead:
=SUMIF(List,">"&LARGE(List,LgList),List)+(LgList-COUNTIF(List,">"&LARGE(List,LgList)))*LARGE(List,LgList)

where List is the range of numbers, and LgList is, in this case, 20.

 

[RagDyer]

Try this:

=SUM(INDEX(LARGE(A1:A500,ROW(1:20)),0))

 

[John C]

nice!
--
John C

Try this:

=SUM(INDEX(LARGE(A1:A500,ROW(1:20)),0))