I am trying to create a rolling total based on the previous 4 quarters. My
plan is to add a column to the left of the sum column. How do I sum the
numbers using the last four columns to the left without having to redefine
the range everytime. I know the "left" function counts a specific number of
characters in the cell to the left, but how do you set a range to the "4
cells to the left" without referencing the specific cells (a1:a4)?