running total formula for inventory

[GMPRINT1]

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

 

[Special-K99]

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.

 

[RCBricker]

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

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

 

[GMPRINT1]

Thank you this has solved it!