How to add cells but keep 2 lowest out of solution

  • Thread starter Thread starter sross002
  • Start date Start date
S

sross002

Hello,

I need help with adding up a column of values in 'X' amount of cells, but I
don't want to include the lowest cells in the addition.

For example, I want to add cells A1:A5. But I want the answer to eliminate
the two lowest cells out of the equation.

This is a sheet I update daily and I need the sheet to recognize the lowest
cells daily. The lowest cells will always be changing.

Please, can someone help? I have Office 2003 for Windows.

If you need more information from me, please let me know.
 
=SUM(A1:A5)-MIN(A1:A5)-SMALL(A1:A5,2)
--
Jim Cone
Portland, Oregon USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)


"sross002"
wrote in message
Hello,
I need help with adding up a column of values in 'X' amount of cells, but I
don't want to include the lowest cells in the addition.

For example, I want to add cells A1:A5. But I want the answer to eliminate
the two lowest cells out of the equation.

This is a sheet I update daily and I need the sheet to recognize the lowest
cells daily. The lowest cells will always be changing.

Please, can someone help? I have Office 2003 for Windows.
If you need more information from me, please let me know.
 
Thanks!

But how would I incorporate that into the formula I already have in the cells.

Here is the formula I already have: =VLOOKUP(D2,A$2:B$41,2, TRUE)
 
If the Sum formula is in cell F2 then...
=VLOOKUP(D2,A$2:B$41,2, TRUE)+F2
--
Jim Cone




"sross002"
wrote in message
Thanks!
But how would I incorporate that into the formula I already have in the cells.
Here is the formula I already have: =VLOOKUP(D2,A$2:B$41,2, TRUE)
 
Back
Top