software

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 quot;leftquot; function counts a specific number of
characters in the cell to the left, but how do you set a range to the quot;4
cells to the leftquot; without referencing the specific cells (a1:a4)?

Try something like this:

For values in A11
E1: =SUM(OFFSET(E1,0,-4,1,4))

That formula always sums the 4-cell range preceding the formula cell.

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Proquot;Debquot; wrote:

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

Thank you very much for your timely response! You saved the day.

quot;Ron Coderrequot; wrote:

gt; Try something like this:
gt;
gt; For values in A11
gt; E1: =SUM(OFFSET(E1,0,-4,1,4))
gt;
gt; That formula always sums the 4-cell range preceding the formula cell.
gt;
gt; Does that help?
gt;
gt; ***********
gt; Regards,
gt; Ron
gt;
gt; XL2002, WinXP-Pro
gt;
gt;
gt; quot;Debquot; wrote:
gt;
gt; gt; I am trying to create a rolling total based on the previous 4 quarters. My
gt; gt; plan is to add a column to the left of the sum column. How do I sum the
gt; gt; numbers using the last four columns to the left without having to redefine
gt; gt; the range everytime. I know the quot;leftquot; function counts a specific number of
gt; gt; characters in the cell to the left, but how do you set a range to the quot;4
gt; gt; cells to the leftquot; without referencing the specific cells (a1:a4)?