View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Rosenfeld
 
Posts: n/a
Default 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