# running total formula for inventory

#### GMPRINT1

##### New Member
Hello,
I am usually pretty good with formulas, but today I cannot get this to work.

I want to keep track of issued printed goods to a customer.

I have the total in cell G3 which is 1000
In cell G4 i want to keep track of the balance.
in the cells below will be the issued stock on a weekly basis, so eg, G5 10, G6 15, G7 20 etc.

the way it is working currently is the following formula which is very long and as i add rows to the page i have to manually input those rows into the formula. =SUM(G3-G5-G6-G7-G8-G9-G10-G11-G12-G13-G14-G15-G16-G17-G18-G19-G20-G21-G22-G23-G24-G25-G26-G27-G28-G29-G30-G31-G32-G33-G34-G36-G37)

HELP PLEASE

### Excel Facts

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).

#### Special-K99

##### Well-known Member
You dont need SUM() around that calculation, you're not actually summing anything (even if you're subtracting).
=SUM(100-20-10) is the same as =100-20-10

If the weekly stock that hasnt been entered yet is 0 or blank until it does get entered then just do

in G4
=G3-SUM(G5:G10000)

This allows for just less than 10000 weeks of stock to be entered.

Last edited:

#### RCBricker

##### Well-known Member
hello,
i am usually pretty good with formulas, but today i cannot get this to work.

I want to keep track of issued printed goods to a customer.

I have the total in cell g3 which is 1000
in cell g4 i want to keep track of the balance.
In the cells below will be the issued stock on a weekly basis, so eg, g5 10, g6 15, g7 20 etc.

The way it is working currently is the following formula which is very long and as i add rows to the page i have to manually input those rows into the formula. =sum(g3-g5-g6-g7-g8-g9-g10-g11-g12-g13-g14-g15-g16-g17-g18-g19-g20-g21-g22-g23-g24-g25-g26-g27-g28-g29-g30-g31-g32-g33-g34-g36-g37)

help please

Code:
``=sum(g3-sum(g4:index(g4:g1048576,match(true,index(isblank(g4:g1048576),0,0),0)-1,0))``

#### GMPRINT1

##### New Member
Thank you this has solved it!

Replies
11
Views
226
Replies
4
Views
217
Replies
5
Views
303
Replies
4
Views
158
Replies
6
Views
331

Threads
1,191,177
Messages
5,985,140
Members
439,942
Latest member
bkexcel11230

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

### Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back