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.