HOW TO TOTAL THE THREE HIGHEST AMOUNTS IN A ROW
 

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

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

HOW TO TOTAL THE THREE HIGHEST AMOUNTS IN A ROW
 

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

To sum up 3 highest values in row 1


Gord Dibben MS Excel MVP

On Wed, 21 Jan 2009 08:49:03 -0800, 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