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
Bookmarks