B
Brian
I am using the following formula but it will involve nesting 12 functions. I
understand the limit is 7. Is there a way to write the formula to avoid the
nesting restriction? The first part of the formula is below and it needs to
continue from sum(A1:K1) to sum(A1:J1) to sum(A1:I1) and so on 12 times
until it reaches A1.
=if(L1>0,'WS2'!M1,if(K1>0,sum('WS2'!A1:K1),if(J1>0,sum('WS2"!A1:J1)... (and
so on),0)))))
Thanks for your help.
understand the limit is 7. Is there a way to write the formula to avoid the
nesting restriction? The first part of the formula is below and it needs to
continue from sum(A1:K1) to sum(A1:J1) to sum(A1:I1) and so on 12 times
until it reaches A1.
=if(L1>0,'WS2'!M1,if(K1>0,sum('WS2'!A1:K1),if(J1>0,sum('WS2"!A1:J1)... (and
so on),0)))))
Thanks for your help.