How to add cells but keep 2 lowest out of solution

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

sross002 - 22 Apr 2008 14:03 GMT

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.

Reply to this Message

Jim Cone - 22 Apr 2008 14:34 GMT

=SUM(A1:A5)-MIN(A1:A5)-SMALL(A1:A5,2)

Signature

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.

Reply to this Message

sross002 - 22 Apr 2008 15:07 GMT

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)

> =SUM(A1:A5)-MIN(A1:A5)-SMALL(A1:A5,2)

Reply to this Message

Jim Cone - 22 Apr 2008 16:19 GMT

If the Sum formula is in cell F2 then...
=VLOOKUP(D2,A$2:B$41,2, TRUE)+F2

Signature

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)

"Jim Cone" wrote:

> =SUM(A1:A5)-MIN(A1:A5)-SMALL(A1:A5,2)

> "sross002"
> wrote in message
[quoted text clipped - 10 lines]
> Please, can someone help? I have Office 2003 for Windows.
> If you need more information from me, please let me know.

Reply to this Message

Rate this thread: