Running Total Formula Help
I am trying to subtract a list of numbers from a begining number.
Example... I have 480,000 parts...... I have a list of usage by week. I am trying to get a balance after each week.
Here is what I am trying to get
10/5/2008 10,000 470,000
10/12/2008 15,000 455,000
10/19/2008 5,000 400,000
I am trying to get a formula to create my running total (shown in bold)