View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary''s Student
 
Posts: n/a
Default calculate best 4 out of 6 columns

Here is a small answer:

if the values are in A1 thru A6, then:

=SUM(A1:A6)-SMALL(A1:A6,1)-SMALL(A1:A6,2)
is what you need
--
Gary's Student


"MSandy" wrote:

i'm new to using microsoft excel. I am currently running excel 2000 and
would like to calculate the sum of the 4 highest numbers out of 6 . Can
anyone help me ?