calculate best 4 out of 6 columns
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 ? |
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 ? |
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 ? |
All times are GMT +1. The time now is 12:50 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com