Decrementing cell reference in formula when autofilling?

Hi guys,

I am trying to auto fill (downwards) with a decrementing reference's in the formula however I cannot find a way:

E.g. I want the references to decrement.

=AVERAGE(G1442,G2908,G4374,G5840,G7306)
=AVERAGE(G1441,G2907,G4373,G5839,G7305)
=AVERAGE(G1440,G2906,G4372,G5838,G7304)
=AVERAGE(G1439,G2905,G4371,G5837,G7303)


I have been doing this manually for some time now, hopefully there is an easier way, formula or technique.


Thank you for your time,


Regards,



Rick.

You could do this in your first cell:

=AVERAGE(INDIRECT("G"&1443-ROWS($1:1)),INDIRECT("G"&2909-ROWS($1:1)),INDIRECT("G"&4375-ROWS($1:1)),INDIRECT("G"&5841-ROWS($1:1)),INDIRECT("G"&7307-ROWS($1:1)))

and then copy down.

Hope this helps.

Pete

Thank you so much Pete works a charm,

I had 1,400 entries to edit, you just saved me a days work!!

Very much appreciated!!!!!

Regards,


Rick.