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(L10,'WS2'!M1,if(K10,sum('WS2'!A1:K1),if(J10 ,sum('WS2"!A1:J1)... (and
so on),0)))))

Thanks for your help.
--
Brian