Formula for Dynamic Range?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

VCUE - 06 Oct 2007 04:37 GMT

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

Reply to this Message

Max - 06 Oct 2007 05:02 GMT

> 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?

Signature

Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

Reply to this Message

VCUE - 06 Oct 2007 06:11 GMT

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

> > Row3
> > Needs to include formula that results in
[quoted text clipped - 3 lines]
> given the values in A1:F1 and in A2:F2, and explain the logic behind how
> these values are computed?

Reply to this Message

Roger Govier - 06 Oct 2007 07:56 GMT

Hi

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

Signature

Regards
Roger Govier

>I am using logical functions:
> Row1 is: "Month"# formated cells
[quoted text clipped - 15 lines]
>> given the values in A1:F1 and in A2:F2, and explain the logic behind how
>> these values are computed?

Reply to this Message