calculate best 4 out of 6 columns

M

MSandy

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

Gary''s Student

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
 
R

Ron Coderre

Try this:

For values in A1:F1 and "best" meaning the largest:

G1: =SUM(LARGE(A1:F1,{1,2,3,4}))

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro
 
Top