What i need is a line of code that does the following.
the data im taking the avg of is in J2:J(x), where x will increase. ill put the avg value in the AA2:AA(x) value in the same row.
so in AA2, the value will be the same as J2
in AA3 the value will be (J2+J3)/2
in AA(x) the value is (J2+...+J(x))/(x-1)
say this is the J row:
HTML Code: 
Thent his will be the vlaues in AA:
HTML Code: 
I want this to be part of a code. Currently i have a code that gathers data, and puts it into a row: so it will fill in all the other values, and when it has filled it all out, i want it to do this. fill in the latest row in the column AA. and the value of the latest AA cell should be the average of all the values in J:J so far. I got suggested earlier that
HTML Code: 
could work, but it is givng me all sorts of errors, and i cant figure out why/what is failing.

any help is appreciated