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

Referencing Row Range in another cell
 

If? you are saying that you want=sum(f1340:g1672) then just drag to the
right

--
Don Guillett
SalesAid Software

"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

Referencing Row Range in another cell
 

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

Referencing Row Range in another cell
 

Okay, let me try and explain better...
I have about 7 different spreadsheets with 4000+ rows which subtotals that
range from just a couple row F2 - F333, then the next subtotaled group range
is F335 - F1277, etc.
Each spreadsheet has different subtotaled ranges or groups.
Its a real PIA to go through each group and copy the range over to the next
column. Instead I would like to place a dynamic function into the adjoining
column which looks at the column next to it and grabs the range (instead of
the val) and lets me dynamically set the function in the adjoining column to
that range.
For example:

Cell F334 contains a function referencing range F2-F33, ie: =SUM(F2:F333)
Cell G334 contains a dynamic function which uses the range identified in
cellF3334, ie: =SUM(referenceRange(F334))

Any ideas?




"Don Guillett" wrote:

If? you are saying that you want=sum(f1340:g1672) then just drag to the
right

--
Don Guillett
SalesAid Software

"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

Referencing Row Range in another cell
 

Yes, Unless I'm seriously missing something just grab the fill handle on the
bottom right and drag to the right.

--
Don Guillett
SalesAid Software

"DJS" wrote in message
...
Okay, let me try and explain better...
I have about 7 different spreadsheets with 4000+ rows which subtotals that
range from just a couple row F2 - F333, then the next subtotaled group
range
is F335 - F1277, etc.
Each spreadsheet has different subtotaled ranges or groups.
Its a real PIA to go through each group and copy the range over to the
next
column. Instead I would like to place a dynamic function into the
adjoining
column which looks at the column next to it and grabs the range (instead
of
the val) and lets me dynamically set the function in the adjoining column
to
that range.
For example:

Cell F334 contains a function referencing range F2-F33, ie: =SUM(F2:F333)
Cell G334 contains a dynamic function which uses the range identified in
cellF3334, ie: =SUM(referenceRange(F334))

Any ideas?




"Don Guillett" wrote:

If? you are saying that you want=sum(f1340:g1672) then just drag to the
right

--
Don Guillett
SalesAid Software

"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