Creating A Running Inventory

**Caspers** · 05-06-2007, 03:10 PM

I am trying to create a running inventory for my liquor. What I want to be able to do is have a column that you can input a positive or negative number and have it added or subtracted from the following column.

For Example:

| 1 | | 1 |
| 1 | | 2 | <--------All the same row
| 2 | | 4 |
| -1 | | 3 |

These of course would all be in the same row, and could be re-entered and re-added to the total.

If someone could help me out with the sum function to put in the box it would be greatly appreciated!!

**WinteE** · 05-07-2007, 05:32 AM

A1 = 1, B1 = Sum($A$1;A1)
A2 = 2, copy B1 to B2
... and so on

**Caspers** · 05-07-2007, 04:47 PM

=SUM($A$4:A4) Doesn't add to the current total. What I am trying to do is add a number to column 1 and it add it to the running total of the next column. So if I type 1 for my first number the total is 1; if i type 2 for the following number the total now becomes 3. I entered this formula and it doesn't want to add the number to the total. Any help again will be greatly appreciated.