S
Snoopy
Hey guys
I have this idea of making my summary useing dynamic range-reference.
EXAMPLE
Monthly amounts is placed i cell A4 to L4 (Jan...Dec)
My issue is to make the formula: =SUM(A4:?4) dynamic to respond to an
index from 1 to 12 and by this re-construct itself.
The months in indexed like this:
January (first month i the summary) is indexed as value 1 in cell A1
The last index in the summary is (ex) 10 representing October is
indexed in cell B1
Index 1 construct the formula =SUM(A4:A4)
Index 2 construct the formula =SUM(A4:B4)
Index 10 construct the formula =SUM(A4:J4)
and so on.
So far I have made a "formual" by using the =ADRESS formula to create
the expression of the cellreferences that marks the range.
LIKE THIS
="=SUM("&ADRESSE(A1;A1)&":"&ADRESSE(A1;B1)&")"
This expression is perfectly dynamic. A copy/paste special-value make
the cell content
=SUM($C$4:$J$4)
BUT
This appears as a text and NOT as a formula!
MY QUESTION IS
How do I get further making this expression work as a real dynamic
formula
I have tried to use replace-function in various way - without suksess.
Please give me a pleasant weekend by guiding me throug this problem
Regards Snoopy
I have this idea of making my summary useing dynamic range-reference.
EXAMPLE
Monthly amounts is placed i cell A4 to L4 (Jan...Dec)
My issue is to make the formula: =SUM(A4:?4) dynamic to respond to an
index from 1 to 12 and by this re-construct itself.
The months in indexed like this:
January (first month i the summary) is indexed as value 1 in cell A1
The last index in the summary is (ex) 10 representing October is
indexed in cell B1
Index 1 construct the formula =SUM(A4:A4)
Index 2 construct the formula =SUM(A4:B4)
Index 10 construct the formula =SUM(A4:J4)
and so on.
So far I have made a "formual" by using the =ADRESS formula to create
the expression of the cellreferences that marks the range.
LIKE THIS
="=SUM("&ADRESSE(A1;A1)&":"&ADRESSE(A1;B1)&")"
This expression is perfectly dynamic. A copy/paste special-value make
the cell content
=SUM($C$4:$J$4)
BUT
This appears as a text and NOT as a formula!
MY QUESTION IS
How do I get further making this expression work as a real dynamic
formula
I have tried to use replace-function in various way - without suksess.
Please give me a pleasant weekend by guiding me throug this problem
Regards Snoopy