| 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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
average range growing
Hi Josh
Use this formula: =SUM(E12:E50)/COUNTA(E12:E50) Regards, Per On 4 Nov., 16:42, jamccarley wrote: 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
average range growing
If the macro is adding data, have the same macro modify the =AVERAGE() formula.
-- Gary''s Student - gsnu200908 |
| Reply |
| 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 | |||
Linear Mode
