YTD totals

[fawns]

Hi

I have a spreadsheet that has two columns

a2 is weekly totals
b2 is ytd totals

Is there a way to add the a2 weekly totals to the YTD column. Also
because the weekly is always changing is there a way of keeping a
running total without having to make 52 columns for the sum.

Thanks

 

[Joel]

Thre are a number of ways of doing what you want. Some methods require a
macro and other can be done with worksheet functions. I think the best way
is to have a master sheet with all 52 weeks and then a weekly sheet that has
the latest amount in one column and the ytd in a 2nd column. This can be
done with just using worksheet formulas

What you asked for with only two columns can't be done with a wroksheet
formula. You would need a formula that would do something like this


A1 = weekly amount
A2 = YTD

The formula in A2 would be this : = A1 + A2
You would get a Circular error since you are using A2 in the formula for
cell A2.

This can be done with a macro. but you loose the old data each week and you
wouldn't be able to check when any errors occurred. Once you add the current
week to the previous ytd you no longer have the previous week nor the old
ytd. You wouldn't be able to change the ytd if any numbers have change
except to go back and make a manual adujustment which is error prone.