Formula for Dynamic Range?

V

VCUE

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
 
M

Max

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

VCUE

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top