Calculate top 10

Posted by Alan Smith on January 15, 2002 5:46 AM

I have a number of rows all with different figures in each column (about 28 columns). How can I do a function which only adds the ten highest figures in each row, I know you can do the top x amount in columns but how is it done in Rows. There are too many rows for me to do a sort into order.

Posted by Mark W. on January 15, 2002 6:48 AM

=SUM(LARGE(B1:AC1,ROW(1:10)))

Posted by Mark W. on January 15, 2002 6:50 AM

Failed to mention...

This is an array formula which must be
entered using the Control+Shift+Enter key
combination.