View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
DJS DJS is offline
external usenet poster
 
Posts: 31
Default 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