Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Trending News
OpenOffice spreadsheet?
Hi can someone help me? This is so simple but I can't figure it out. I basically only want to use 1 column. (if this can be done)
All I want to do is have deposits & then expenses for a calendar year.
I named column "A" as above but I can't get the sum. It's doesn't appear on the bottom either.(sum)
It may be 3,4 or 5 deposits in a row & then
an expense. All I want to do is keep a running total.
Thanks for your help.
2 Answers
- Steve DLv 76 years agoFavorite Answer
You need more than 1 column...three columns would be good - first column is whatever the transaction is (i.e., deposit paycheck), second column is the amount (plus for a deposit, minus for a withdrawal) and third column is your running total...start in row one, column C, put your starting balance, In the next row, column C, you have the formula =C1+B2 - then you just copy that all the way down.
the only way you can do one column is to guess how many transactions you are going to have, leave a bunch of blank cells and at the bottom, use the formula "=@sum(a1.awhatever) where whatever is the last blank cell.
Or you can just start at cell a2 and plug in the formula =@sum(a1.A1) and keep inserting lines every time you have a new transaction. The
- Ziff SpiffingtonLv 76 years ago
if you just want a net figure, then enter the expenses as a negative number and total everything up , other use 2 columns
