| Home |
| Search |
| Today's Posts |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I calculate an average of the last 5 nonblank cells in
No it doesn't: it's the largest 5 values!
"excelent" wrote: another way =AVERAGE(LARGE(A1:A3000,ROW(INDIRECT("1:" & 5)))) hit ctrl+shift+enter returns average of last 5 cells in range A1:A3000 "excelent" skrev: UPS ur right Toppers =AVERAGE(IF(ROW(A1:A30)=LARGE(IF(ISNUMBER(A1:A30) ,IF(A1:A300,ROW(A1:A30))),MIN(B1,COUNTIF(A1:A30," 0"))),IF(A1:A300,A1:A30))) "Toppers" skrev: Perhaps AVERAGE instead of MID?! "excelent" wrote: put 5 in cell B1 "excelent" skrev: =MID(IF(ROW(A1:A30)=LARGE(IF(ISNUMBER(A1:A30),IF( A1:A300,ROW(A1:A30))),MIN(B1,COUNTIF(A1:A30,"0") )),IF(A1:A300,A1:A30))) INSERT AND HIT CTRL+SHIFT+ENTER " skrev: I am trying to average only the last 5 nonblank values in a row of cells. Is this possible? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| tally of nonblank cells | Excel Worksheet Functions | |||
| Display first, second, etc Nonblank Cells in a Range | Excel Worksheet Functions | |||
| counting nonblank cells | Excel Worksheet Functions | |||
| Excel cannot shift nonblank cells | Excel Discussion (Misc queries) | |||
| Adding NonBlank Cells | Excel Worksheet Functions | |||
Threaded Mode
