| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
average range growing
I have a CPK sheet that i am having a CMM dump data into automaticlly. My
problem is I need the formula for the average to grow along with the additon of cells that I insert with a macro. Right now the formula is just =AVERAGE(E12:E12)because there is only one line, but when I insert a cell I want it to change to =AVERAGE(E12:E13)....etc..etc. How would I accomplish this? Thanks Josh McCarley |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Populate growing range of cells from Sheet1 to Sheet2 | New Users to Excel | |||
| File size growing growing exponentially | Excel Discussion (Misc queries) | |||
| subtotal filter with growing range | Excel Discussion (Misc queries) | |||
| AVERAGE a range in a column if another column's range equals a val | Excel Discussion (Misc queries) | |||
| Growing range within a Sumproduct. | Excel Worksheet Functions | |||
Threaded Mode
