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
|