| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
How can I average certain number of lowest values in a column?
How can I average certain number of lowest values in a column?
|
|
#2
|
|||
|
|||
|
The following array formula will average the lowest 5 numbers in
A1:A10. =AVERAGE(SMALL(A1:A10,ROW(INDIRECT("1:5")))) Change the 1:5 to 1:N where N is the number of values you want to average. Since this is an array formula, you must press Ctrl+Shift+Enter rather than just Enter when you first enter the formula and whenever you edit it later. If you do this properly, Excel will display the formula enclosed in curly braces {}. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Philcw" wrote in message ... How can I average certain number of lowest values in a column? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Error Handling #N/A with AVERAGE Function - Average of values in Row | Excel Worksheet Functions | |||
| Count number of values in a cell | Excel Worksheet Functions | |||
| lowest number above 0 | Excel Discussion (Misc queries) | |||
| get lowest positive number | Excel Discussion (Misc queries) | |||
| Is there a way to have two values (percent and number) in a label. | Charts and Charting in Excel | |||
Hybrid Mode
