=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