I've got a sheet in Google Sheets that tracks a large inventory. I want to quickly see the total of the last three months (columns) but ONLY the last three months. So far it looks something like this:
3 MO TOTALS APRIL MARCH FEB JAN APPLES 10 2 4 4 4 BANANAS 5 0 2 3 2 CARROTS 0 0 0 0 1
The issue comes when it's time for a new column to be added. If I use
=SUM, the formula changes from
=SUM($C2:$E2) also does not work.
If I use
=sum(indirect("C2:E2")), I cannot copy the formula easily and I have over 300 rows of entries and add new ones frequently.
How do I keep absolute column ranges without writing out each row's formula manually?