In cell A1, I have the simple formula =Sum(A12:A16)
In cell B1 I have =SUM(B12:B16).
Tomorrow I might modify my formula in cell A1 to be =Sum (A17:A54); obviously, B1 will have =Sum(B17:B54)
How can I make it so that cell B1's formula reads A1's formula and knows to change the range automatically? Is there some sort of offset formula or something?
The problem is that I have 30 columns worth of information with the sum formula in row 1. I do not like updating every column each morning as the data ranges change from day to day.
I do appreciate your help.
In cell B1 I have =SUM(B12:B16).
Tomorrow I might modify my formula in cell A1 to be =Sum (A17:A54); obviously, B1 will have =Sum(B17:B54)
How can I make it so that cell B1's formula reads A1's formula and knows to change the range automatically? Is there some sort of offset formula or something?
The problem is that I have 30 columns worth of information with the sum formula in row 1. I do not like updating every column each morning as the data ranges change from day to day.
I do appreciate your help.