One way ..

In C1:
=SUM(OFFSET($A$1:$A$4,,ROW(A1)-1))
Copy down
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"jefe96" wrote:
I have the following data and am trying to copy the sum function to create a
running total. When I copy the formula it keeps the same column and I need
it to jump to the subsequent column. Assume this data is in columns A and B
starting in A1.

1 5 =sum(A1:A4)
2 6 =sum(b1:B4) This is what I want to happen but when I
copy the
3 7 formula in C1 to C2 it keeps the
formula in the A
4 8 column and just switches the
range. Is there any
way to have it jump to the
next column without having
to manually change it?