| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Selecting the top 4 largest value cells??
I am tryijng to sum the largest 4 values in a column of cells.
I used: SUM(LARGE(A1:A10,{1,2,3,4})) which seems to work fine in general, however, if any of the top 4 largest values is the same, then it yeilds an incorrect sum. How can I overcome this failure? I need to include duplicate values in my sum. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Selecting cells using shortcut keys not mouse | Excel Discussion (Misc queries) | |||
| selecting multiple cells with ctrl key | Charts and Charting in Excel | |||
| Excel 97 - Selecting multiple cells from 2 different Pivot Tables | Excel Discussion (Misc queries) | |||
| Selecting shaded cells in a row | Excel Worksheet Functions | |||
| Ranking cells largest to smallest | Excel Discussion (Misc queries) | |||
Threaded Mode
