Referencing Row Range in another cell
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
|