calculate best 4 out of 6 columns
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
"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 ?
|