Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Two cell accumulator
I would like to know if it is possible to have a running total using only two
cells. I have many rows of items that are tracked each week and each item rolls up to a monthly total. What I would like is to have the following: B1: =A1+B1, B2: =A2+b2, B3: =A3+B3 and so on. I need only the row where a change was made (A1, A2, A3, etc.) to caculate at the time of the change leaving the other rows unchanged. What I am doing now is taking last weeks entry and manually adding to the monthly total for each item. I sure hope someone can help me with this, as I make mistakes adding. -- Bill |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell color based upon cell value | Excel Discussion (Misc queries) | |||
cell color index comparison | New Users to Excel | |||
Cell Change Color - Need Help | New Users to Excel | |||
GET.CELL | Excel Worksheet Functions | |||
VLookup resulting in a blank cell... | Excel Worksheet Functions |