Help on Easy If Function

[RMGraham]

I have this in my cell and it wont work.

=IF($DB$4=1,B9,IF($DB$4=2,B9+H9,IF($DB$4=3,B9+H9+N9,IF($DB$4=4,B9+H9+N9+T9,IF($DB$4=5,B9+H9+N9+T9+Z9,IF($DB$4=6,B9+H9+N9+T9+Z9+AF9,IF($DB$4=7,B9+H9+N9+T9+Z9+AF9+AL9,IF($DB$4=8,B9+H9+N9+T9+Z9+AF9+AL9+AR9,IF($DB$4=9,B9+H9+N9+T9+Z9+AF9+AL9+AR9+AX9,""))))))))


It always highlights on the bold part

Help

[CheshireCat]

How about:

Please Login or Register  to view this content.

[tigeravatar]

RMGraham,

Perhaps like this instead?

Please Login or Register  to view this content.

[EDIT]
Nice use of Choose, CheshireCat

[K m]

It looks as if you have a space between one of your variable names. Why not try this:
=CHOOSE($DB$4,B9,B9+H9,B9+H9+N9,B9+H9+N9+T9,B9+H9+N9+T9+AF9,B9+H9+N9+T9+AF9,B9+H9+N9+T9+AF9+AL9,B9+H9+N9+T9+AF9+AL9+AR9,B9+H9+N9+T9+AF9+AL9+AR9+AX9)

[martindwilson]

easiest is with a helper to create a contiguous array and a dynamic range
edited to include col z

[Haseeb Avarakkan]

looks you are summing every 6th column, so Try this,

=SUMPRODUCT((MOD(COLUMN(B9:AX9)-COLUMN(B9),6)=0)*(COLUMN(B9:AX9)-COLUMN(B9)+1<=A1*6),B9:AX9)

[martindwilson]

hasseb a what about col z and where is the value in db4 taken into consideration?

[Haseeb Avarakkan]

Hello Martin,

I don't see any specialty with column Z. Since 5th number OP has Z9 on sum range. For DB4 it was typo, A1 should be DB4. here is the corrected version.

=SUMPRODUCT((MOD(COLUMN(B9:AX9)-COLUMN(B9),6)=0)*(COLUMN(B9:AX9)-COLUMN(B9)+1<=$DB$4*6),B9:AX9)

[martindwilson]

slightly shorter than above this works

Please Login or Register  to view this content.

apologies hasseb a by post #4 which i looked at col z was missing
B9+H9+N9+T9+AF9+AL9+AR9+AX9