How to fill series with a formula?

[jake.peterson]

I need to copy a formula and drag it down several thousand columns.

is there a way to make the formula change as you copy down the column like a fill series option?

for example, my formula is:
=ABS((AVERAGE($J$3:$O$3)-$O$3)/(AVERAGE($J$3:$O$3)))

But when I drag it to row 4 it remains the same formula for row 3.
Can I have this updated somehow without manually re-writing the formula a thousand times?

 

[Andrew Poulsom]

Remove the $ signs before the row reference. They cause it to be absolute rather than relative when copying.

 

[1968rm]

Use this: =ABS((AVERAGE(J3:O3)-O3)/(AVERAGE(J3:O3)))

 

[jake.peterson]

Obviously
Thanks Andrew.