Formula for Dynamic Range?
 

I am inexperienced and need help:

Need to create formula for:

A B C D E F
Row1 1 2 3 4 5 6
Row2 2 4 6 8 10 12

Row3
Needs to include formula
that results in range changes in row2 based on the value cell in row1.

I do not have an idea of what to use.
Thanks

Formula for Dynamic Range?
 

Row3
Needs to include formula that results in
range changes in row2 based on the value cell in row1.

Can you provide some sample values of what should appear in A3, B3, ... F3
given the values in A1:F1 and in A2:F2, and explain the logic behind how
these values are computed?
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

Formula for Dynamic Range?
 

I am using logical functions:
Row1 is: "Month"# formated cells
Row2 are incremental values (not necessarily B2*2=4)
In Row3, For example =if(B5=C1,SUM($A$2:C2),SUM of a range that moves one
column to the right starting at A3 and that will expand until the range in
row3 will COUNT the number of cells that is equivalent to an arbitrary value
in B5

THX in advance MAX

"Max" wrote:

Row3
Needs to include formula that results in
range changes in row2 based on the value cell in row1.

Can you provide some sample values of what should appear in A3, B3, ... F3
given the values in A1:F1 and in A2:F2, and explain the logic behind how
these values are computed?
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

Formula for Dynamic Range?
 

Hi

I'm not sure that I understand what you are trying to achieve.
Perhaps something like
=SUM(INDIRECT("A2:"&CHAR(64+B5)&"2"))

--
Regards
Roger Govier



"VCUE" wrote in message
...
I am using logical functions:
Row1 is: "Month"# formated cells
Row2 are incremental values (not necessarily B2*2=4)
In Row3, For example =if(B5=C1,SUM($A$2:C2),SUM of a range that moves one
column to the right starting at A3 and that will expand until the range in
row3 will COUNT the number of cells that is equivalent to an arbitrary
value
in B5

THX in advance MAX

"Max" wrote:

Row3
Needs to include formula that results in
range changes in row2 based on the value cell in row1.

Can you provide some sample values of what should appear in A3, B3, ...
F3
given the values in A1:F1 and in A2:F2, and explain the logic behind how
these values are computed?
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---