Running cumulative tally

[cdragin]

Hi there,

Long-time excel user, but have never gotten into it in much depth, so I'm out of my depth here. I have a spreadsheet that has two parts: in the first page, a user logs a number for widgets used per day. In the subsequent pages, there is a running total of widgets per day. So if the original column is B and the tally column is O, day one of the O column is "=B3", day two is "=O3+B4", day three is "=O4+B5", etc. (alternatively, I could set the formula to "=B3", "=B3:B4", "=B3:B5" etc.) Following the tally column are two columns that calculate percentages of change from the previous month and from a baseline average.

I want to do this all 12 months, but don't see a way to cut and paste the info and have it still refer to the correct column. Is there a way to keep the formulas but change all the B's to C's or D's?

FYI, I'm saving in an older version of excel for compatibility with others who have older software.

[NBVC]

Perhaps in O3:

=SUM(O2,INDEX($B$3:$M$33,ROWS($A$1:$A1),MATCH(O$2,$B$2:$M$2,0)))

copied down.

Then you can copy this column to Q3, then T3, then W3, etc...