average range growing

[jamccarley]

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

 

[Per Jessen]

Hi Josh

Use this formula:

=SUM(E12:E50)/COUNTA(E12:E50)

Regards,
Per

 

[Gary''s Student]

If the macro is adding data, have the same macro modify the =AVERAGE() formula.