what formula to get total from two different columns

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a worksheet that i want to use to keep track of my bank account i.e
money in and money out to give me a total in the third column and cannot work
the formula out as 1 column is taking away and the secon column is adding?????
 
If you want a running total the general philosophy is that in the total
column you need one additional cell.

So if inflows are in A2:A10 and outflows are in B2:B10, put your
starting balance in C1 and then in C2 use:

=C1+A2-B2

Does this help?

Kostis Vezerides
 
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

Column total is wrong 5
Adding up total hours worked on employee schedule using various criteria 0
Excel Subtracting multiple columns from another column 3
Total Dollar Amounts From Different Worksheet 5
Cannot get the column to total with =sum 7
Need to get minimum difference 1
Running Total Question 2
Copy formula from one worksheet to another to get value in 2nd wks 1

Back
Top