OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

Running Totals In Calc

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc
View previous topic :: View next topic  
Author Message
d1allan
Newbie
Newbie


Joined: 29 Nov 2008
Posts: 3

PostPosted: Sat Nov 29, 2008 11:01 am    Post subject: Running Totals In Calc Reply with quote

I often create spreadsheets in Calc with 2 number columns, one for a transaction, such as a debit or credit, then another which has a running balance. These are like checkbook registers. I use the sum function to add the previous balance to the new transaction and to create the new running total. I use the copy function to copy the formula and formats to a series of subsequent rows so that new transactions are automatically totalled.
The problems I have are:
A) The running total is entered into all lines for which I have copied the formula, even if no transaction entry has been entered. I would prefer that if no entry has been made, no total is entered on that row.
B) Sometimes I "Stack" these registers on one page. I'm not sure how many entries each will have, so I'd like to have the formula entered into the next line as each transaction is added. That way, I do not have to copy the formula to an arbitrary number of rows to make room for transactions which may never be entered.

I hope somebody understands my babble.
Thanks in advance for your help.
Allan
Back to top
View user's profile Send private message
JohnV
Administrator
Administrator


Joined: 07 Mar 2003
Posts: 9183
Location: Lexinton, Kentucky, USA

PostPosted: Sun Nov 30, 2008 11:21 am    Post subject: Reply with quote

First problem:
Assuming you numbers start in A1 I think this is what you want in B2 and below.
=IF(A2="";"";Sum(A$1:A2))
Back to top
View user's profile Send private message
d1allan
Newbie
Newbie


Joined: 29 Nov 2008
Posts: 3

PostPosted: Mon Dec 01, 2008 7:22 pm    Post subject: Yes! Excellent! Reply with quote

That is exactly what I was looking for in problem #1. Excellent.
Thank you very much.

Very Happy
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group