Hi there,

In cell E3, I would like to sum 21 cells Q3;AC3;AO3;…;IW3. (Note that those cells differ each time 12 columns). The easy formula =sum(Q3;AC3;AO3;…;IW3) results in #N/B. This is because in that cells there are #n/B’s resulting from inner formulas.

I could change all formulas of these cells with IF.NB(…;"") but this is not very efficient…

So, could anyone think about a good formula. This formula is to be copied to E4 until E22, so necessary absolution and dynamic into the formula is needed.

Thanks a lot

Lucca