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

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

average range growing
 

If the macro is adding data, have the same macro modify the =AVERAGE() formula.
--
Gary''s Student - gsnu200908