HOW TO TOTAL THE THREE HIGHEST AMOUNTS IN A ROW

  • Thread starter Thread starter Shane
  • Start date Start date
S

Shane

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
 
=SUM(LARGE(1:1,{1,2,3}))

To sum up 3 highest values in row 1


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Is there an Excel formula to show the highest letter in a row? 1
display order of values without sorting 2
Highlight Highest Amount 2
Highest three numbers in a list 4
Calculating total amount in a Pivot Table 1
Creating a formula to identify highest figure 4
Automatically put rows containing a number in numerical order 1
Find 3 numbers +/- 26 rows from each other 2

Back
Top