Summing the top 100 numbers in a selected range

  • Thread starter Thread starter ZermaPersians
  • Start date Start date
Z

ZermaPersians

I have a worksheet which I would like to sum the totals of the 100 cells
with the highest values in them and place this resultant in a cell of its
own.

Can this be done?
Thanks,
Eric
 
Hi Eric,

If the cells are in a contiguous range like column A:

=SUM(LARGE(A1:A500,ROW(INDIRECT("1:100"))))

Entered as an array - CTRL+SHIFT+ENTER

If the cells are all over the place - well, that'll take
someone else to help!

Biff
 
Back
Top