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