Updating a Running total from a cell
Hi, I have an inventory list that I want to update the "On-Hand" field, keep
the running total, from an update entry into the "this shipment" field for each inventory item. I will not be adding lines, just updating the "this shipment" cell for each product. I want it to look like this: On Hand This Shipment Running Total Product #1 5 3 8 Product #2 10 -5 5 Product #3 20 10 30 Then, when my next shipment comes in i want to key in the "this shipment" and the Running Total field updates. All I can think of is a "circular formula" and that doesn't work. Thanks !!! |
Updating a Running total from a cell
Assuming Product in column A, On Hand column B, This Shipment column C and
Running Total column D. Also Product #1 in row 2. In cell B2 enter =$D2-$C2 Copy down as far as you need to Trust this is what you want? "MacPack2" wrote: Hi, I have an inventory list that I want to update the "On-Hand" field, keep the running total, from an update entry into the "this shipment" field for each inventory item. I will not be adding lines, just updating the "this shipment" cell for each product. I want it to look like this: On Hand This Shipment Running Total Product #1 5 3 8 Product #2 10 -5 5 Product #3 20 10 30 Then, when my next shipment comes in i want to key in the "this shipment" and the Running Total field updates. All I can think of is a "circular formula" and that doesn't work. Thanks !!! |
All times are GMT +1. The time now is 02:46 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com