View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] imnxcguy@yahoo.com is offline
external usenet poster
 
Posts: 4
Default Maximum Numbers from a series of Columns

Hi,

I have to add up the highest 5 numbers from a series of 8 columns.
Some rows will have 5 different numbers, some 6, some 7 or 8. Is there
a way to find the 5 highest from that series, and then have another
equation to add them up?

Thanks,

Mark