LinkBack URL
About LinkBacks
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
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
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
Cheers!
Tsjallie
--------
If your problem is solved, pls mark the thread SOLVED (see Thread Tools in the menu above). Thank you!
If you think design is an expensive waste of time, try doing without ...
Thanks - I did that - I guess I was being lazy and wanted just accumulate the grand total in B
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks