Dilemma In Stock Sheet

  • Thread starter Thread starter Ron Warrington
  • Start date Start date
R

Ron Warrington

Column A is description. B is Current Items. C is Additional Items. D
is Outgoing Items. E is New Balance.
How can I keep a running total with each set of additions and
outgoings? The problem is that C needs to change as well as E.
It sounds simple but I can't fathom it out. Any help will be much
appreciated
 
Hi
in E1 enter the formula
=B1+C1-D1

in E2 enter the formula
=E1+C2-D2
and copy this down
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Tracking Sheet 1
SUM - IF - AND 7
How can I ignore blanks when concatenating cells in Excel? 5
Formula help...=IF? 1
Totaling with "IF" 1
adding and subtracting using vb codes 2
Code to Allocate Funds 2
cumalative total 2

Back
Top