Greetings,

I want to make a relative 3d sum, so when I insert a row in the whole workbook the 3d sum still sums the worksheets total for the row the sum function is in: the non relative function is:

=SUM('Shared (000):Donor Ed (610)'!F54)

I tried to replace the cell reference of F54 with the following, but Excel doesnt like it much.

=SUM('Shared (000):Donor Ed (610)'!address(row(),column(),4,,))

Thanks in advance for your suggestions.

Jim