| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Total the highest 5 of 8 amounts. | New Users to Excel | |||
| only total cells with $ amounts | Excel Discussion (Misc queries) | |||
| how to total amounts in one colum | Excel Worksheet Functions | |||
| Is it possible to get a sub-total of amounts when... | Excel Discussion (Misc queries) | |||
| Linking total amounts | Excel Worksheet Functions | |||
Linear Mode
