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