Problem: Sum same cells in different sheet in a ROBUST way

[hugolm]

Hi everyone!

Here is my problem. I am trying to sum the same cells in different sheet (same template). I create 2 boundaries sheets (BEG and END). Then I use the formula SUM(BEG:END!B2). It works well. However, it is not robust because If I insert a new row before row B in this case, my formula become out of line.
I was thinking using a sum over an indirect address but It doesnt work
SUMPRODUCT(--N(INDIRECT("BEG:END!"&ADDRESS(ROW(F250);COLUMN(T$5)))))

I am pretty upset since I did this formula in the past but I cannot find it again. So if you have any idea. I would be very grateful.
Thanks in advance,

Hugo

 

[Andrew Poulsom]

Welcome to MrExcel.

Unfortunately, INDIRECT won't resolve a 3D reference like BEG:END. Maybe this will help you:

http://answers.microsoft.com/en-us/...-accross/06e763c1-e169-47cd-af5e-c963fe1e80e6

 

[hugolm]

Thanks for your answer!