Not sure what you are asking. Do you want to use the same rows AND column ?

If so, make the formula in F1673: =SUM($F1340:$F1672). Then copy and
paste.

If you want the same rows but refer to column G, just copy and paste the
formula

Regards

Trevor


"DJS" wrote in message
...
Ok Guru's, this is an easy one but I am having trouble finding the answer:

In cell F1673 I have a formula:
=SUM(F1340:F1672)

I would like to reference and utilize the same rows in cell G1673 without
having to continuously copying F to G.
Can I reference the range used in the formula in cell F1673 by using
Address, Indirect, or something similar?

TIA