Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / April 2008

Tip: Looking for answers? Try searching our database.

Updating a Running total from a cell

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
MacPack2 - 11 Apr 2008 17:34 GMT
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 !!!
Ron@Buy - 11 Apr 2008 18:26 GMT
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?

> 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
[quoted text clipped - 10 lines]
> formula" and that doesn't work.
> Thanks !!!
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.