Need to add cells depending on other cell.

[Ashurk77]

Hi
I need to add few cells.
But problem is My number of cells depend on other cells value.
E.G
I want to add values from column A
depending on value in cell B2

suppose its B2 is 2
so i will add A1 and A7
suppose b2 is 3
thn I will add A1 A7 and A13 and so on....

Can some one help.?

Thanks in advance

Refered: http://www.excelforum.com/excel-form...ml#post3488332

 

[Boniouk]

If its as simple as you say, then something like this will work as your sum cell.

=IF(B2=2,SUM(A2+A7),IF(B2=3,SUM(A2+A7+A10),0))

Where B2 is either 2 or 3, it is adding either A2 and A7, or A2,A7 and A10 (if B2 is 3).

 

[Ashurk77]

Nop not poss as I told So on...
It goes on increasing.....
till 500 600 rows


I need to add few cells.
But problem is My number of cells depend on other cells value.
E.G
I want to add values from column AR
depending on value in cell P2

Right now m using
=(SUMIF(AQ$5:AQ$469,AX4,AR$5:AR$469))/P$2

but unsuccessful

suppose if P2 is 2
so i will add AR5 and AR13
suppose p2 is 3
thn I will add AR5 AR13 and AR21 and so on....


Can some one help.?

Thanks in advance

 

[Boniouk]

There is a difference of 6 between your required cells. ie A1 A7 A13. Is this pattern throughout? Does it continue requiring A19, A25? as you enter 4 and 5 in B2?

 

[XOR LX]

Hi,

=SUMPRODUCT(N(OFFSET($A$1,6*(ROW(INDIRECT("1:"&B2))-1),,,)))

Regards

 

[Ashurk77]

@Boniouk
Yes....

 

[Ashurk77]

Hi,

=SUMPRODUCT(N(OFFSET($A$1,6*(ROW(INDIRECT("1:"&B2))-1),,,)))

Regards

Yes Thanks..
But is there some other formula or process as well....?

 

[XOR LX]

Is there something you don't like about this particular approach?

Regards

 

[Ashurk77]

Is there something you don't like about this particular approach?

Regards

problem is I am using Dashboard and Sumproduct is not supporting by Dashboard.

 

[XOR LX]

Never heard of it. What functions are available to you? Can you post a link to a definitive list?

Regards