F
Frustrated
How do you add the top 20 numbers from a list of 500 numbers in a row?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
M
M Kan
=SUMPRODUCT(--(RANK(list_of_values,list_of_values,0)<=20),list_of_values)
J
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.
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.
R
RagDyer
Try this:
=SUM(INDEX(LARGE(A1:A500,ROW(1:20)),0))
=SUM(INDEX(LARGE(A1:A500,ROW(1:20)),0))
J