Adding contents of cell1 to cell2 and store result in cell2

[glenbuck]

Trying to program in excel by adding contents in A to B and store in B

eg a1 = 1: b1 = 2: b1 now = 3: zero out A : column A changes every week

[Tsjallie]

This suggests that b1 contains the formula: =sum(a1:b1), but you can't have data as well as a formule in the same cell.
You can solve this to have this formula in c1.
So a1=1 : b1=2 : c1=3

[glenbuck]

Thanks - I did that - I guess I was being lazy and wanted just accumulate the grand total in B