Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dynamic average
I am looking for a way to average a series of number in a column. I would
like this formula to average the numbers up to a quantity of 20. So, if there are 3 numbers in the column, I would like it to average those 3. If there are 23, I would like it average the last 20. Thanks, Mike. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dynamic average
Say your numbers were in A1 to A100, try this *array* formula:
=AVERAGE(A100:INDEX(A1:A100,LARGE(ROW(1:100)*(A1:A 100<""),20))) -- Array formulas must be entered with CSE, <Ctrl <Shift <Enter, instead of the regular <Enter, which will *automatically* enclose the formula in curly brackets, which *cannot* be done manually. Also, you must use CSE when revising the formula. -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Mike D." wrote in message ... I am looking for a way to average a series of number in a column. I would like this formula to average the numbers up to a quantity of 20. So, if there are 3 numbers in the column, I would like it to average those 3. If there are 23, I would like it average the last 20. Thanks, Mike. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamic average | Excel Worksheet Functions | |||
Dynamic Rolling Average | Excel Worksheet Functions | |||
Dynamic annual average | Charts and Charting in Excel | |||
Dynamic Average Question | Excel Discussion (Misc queries) | |||
Dynamic Average | Excel Worksheet Functions |