| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to get average of successive x-number cells to output in colum
I would like to get the average of 30 cells in a column output to a cell in
another column. Then have the next 30 cells averaged in the next cell down. If I tell excel to get the average 30 cells then copy that to the next cell down it takes the average of the 30 cells starting from row 2 instead of from row 31. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pasting in successive cells | Excel Discussion (Misc queries) | |||
| How to hide running total in successive cells in a column | Excel Worksheet Functions | |||
| how do you divide the average of a number into 3 different cells. | New Users to Excel | |||
| Is there a limit to number of successive IF-THEN statements? | Excel Discussion (Misc queries) | |||
| colum B=average of last 10 values in A | Excel Worksheet Functions | |||
Threaded Mode
