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 !!!

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 !!!