Incrementing numbers in cells

[Andrew Morine]

Hi,

I need to perform the following increments within a cell and need to copy to
a large amount of cells:

=SUM($G7+1)
=SUM($G7+2)
=SUM($G7+3)
etc...
etc...

Any ideas on how I can achieve this?


Thanks heaps
Andrew

 

[Teethless mama]

=$G$7+ROWS($1:1)

copy down