Updating a Running total from a cell

M

MacPack2

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

Ron@Buy

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Running total from an edited cell 1
Running total on a report 2
summing 2 different totals in a continuous form 1
Sorting 1
updating table using user value 1
Creating a new table from another - filtering out unwanted data 8
Count groups rather than detailed records 2
Obtain the same value of the form in a subform 2

Top