That was excellent Ruth, Thanks!

Now, I have another one!

Of the range of cells, say 20 columns, I want to sum the best 14 from
the 20, in order of highest rank.

So say I have 20 columns , with values of 1-20. I want the sum of the
top 14, which would be 20+19+18+…etc.

Any easy way to do this?

Joe


--
berminator
------------------------------------------------------------------------
berminator's Profile: http://www.excelforum.com/member.php...o&userid=24833
View this thread: http://www.excelforum.com/showthread...hreadid=383851