| Home |
| Search |
| Today's Posts |
|
#5
|
|||
|
|||
=SUM(LARGE(A1:A16,ROW(INDIRECT(("1:10")))))
which is an array formula., so commit with Ctrl-Shift-Enter -- HTH RP (remove nothere from the email address if mailing direct) "Michele P" <Michele wrote in message ... I have a row of (16) numbers. I want to sum the top (10) greatest numbers. I know how to get the greatest number by using MAXA, but how do I tell it to get the top ten greatest numbers and add them together? HELP? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
| Missing values in Excel Line Chart | Charts and Charting in Excel | |||
| Generating Correlated Random Values in Excel | Excel Discussion (Misc queries) | |||
| Stop Excel from converting text labels in CSV files to Values | Excel Discussion (Misc queries) | |||
| Paste rows of numbers from Word into single Excel cell | Excel Discussion (Misc queries) | |||
Threaded Mode
