taking out lowest 2 values

G

georgette

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?
 
D

Dave Peterson

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

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

Ron Rosenfeld

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

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

Or, even lazier :)):

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


--ron
 
Top