| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 ? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 ? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 ? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help with grouping columns | New Users to Excel | |||
| How can I calculate columns? | Excel Worksheet Functions | |||
| Hiding columns and custom views problem | Excel Discussion (Misc queries) | |||
| Removing Near-Duplicate Rows, Leaving Those w/Most Data in Specific Columns | Excel Discussion (Misc queries) | |||
| Counting the Contents of Two Columns | Excel Discussion (Misc queries) | |||
Linear Mode
