This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I want to do a new entry in column A monthly. I want it to continuously add to column B. I am stumped. For example, column B is 12 and I enter 4 in column A, I want column B to automatically change to 16. Thanks
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Thank you. I will give that a try. I enter column A monthly so I have it saved to refer back to Column B. I have it save in a file plus a paper copy. Thanks again and have a blessed evening.
That is a dangerous approach:
I'd enter each new entry in a new row in column A, and use a formula in column B to display the running sum.
The formula in B2 is =SUM(A2, B1). This can be filled down.