Thread: HOW TO TOTAL THE THREE HIGHEST AMOUNTS IN A ROW
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
  
Posts: 11,501
Default HOW TO TOTAL THE THREE HIGHEST AMOUNTS IN A ROW
Shane,

=SUM(LARGE(A:A,{1,2,3}))

Mike

"Shane" wrote:

Hi

How do you add up the three highest amounts in cells in a row automatically.
eg: when adding a higher amount in the collum excell must automatically use
the higher amount and egnor the lower amount, thus only totalling the three
highest numbers or scores in the row or colum.

THANKS
--
Shane A. Cawthorn
Reply With QuoteReply With Quote