taking out lowest 2 values
 

Hi, I'm new. Okay, so I'm being a little lazy in that I could sit here
and search threads until i'm blue in the face -- but blue's not a good
color for me. So here's my question:

I want to sum a range of data, but then take off the 2 lowest values.
how do I do it?


--
georgette
------------------------------------------------------------------------
georgette's Profile: http://www.excelforum.com/member.php...o&userid=30289
View this thread: http://www.excelforum.com/showthread...hreadid=499576

taking out lowest 2 values
 

Hi Georgette

One way
=SUM(A1:A100)-SMALL(A1:A100,1)-SMALL(A1:A100,2)


--
Regards

Roger Govier


"georgette"
wrote in message
...

Hi, I'm new. Okay, so I'm being a little lazy in that I could sit
here
and search threads until i'm blue in the face -- but blue's not a good
color for me. So here's my question:

I want to sum a range of data, but then take off the 2 lowest values.
how do I do it?


--
georgette
------------------------------------------------------------------------
georgette's Profile:
http://www.excelforum.com/member.php...o&userid=30289
View this thread:
http://www.excelforum.com/showthread...hreadid=499576

taking out lowest 2 values
 

=sum(a1:a100)-min(a1:a100)-small(a1:a100,2)

or since you're lazy:
=SUM(A1:A100)-SUM(SMALL(A1:A100,{1,2}))




georgette wrote:

Hi, I'm new. Okay, so I'm being a little lazy in that I could sit here
and search threads until i'm blue in the face -- but blue's not a good
color for me. So here's my question:

I want to sum a range of data, but then take off the 2 lowest values.
how do I do it?

--
georgette
------------------------------------------------------------------------
georgette's Profile: http://www.excelforum.com/member.php...o&userid=30289
View this thread: http://www.excelforum.com/showthread...hreadid=499576

--

Dave Peterson

taking out lowest 2 values
 

On Mon, 09 Jan 2006 17:19:24 -0600, Dave Peterson
wrote:

=sum(a1:a100)-min(a1:a100)-small(a1:a100,2)

or since you're lazy:
=SUM(A1:A100)-SUM(SMALL(A1:A100,{1,2}))


Or, even lazier :-)):

=SUM(A1:A30,-SMALL(A1:A30,{1,2}))


--ron

taking out lowest 2 values
 

thanks guys! worked like a charm.


--
georgette
------------------------------------------------------------------------
georgette's Profile: http://www.excelforum.com/member.php...o&userid=30289
View this thread: http://www.excelforum.com/showthread...hreadid=499576