LinuxQuestions.org
Review your favorite Linux distribution.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices


Reply
  Search this Thread
Old 04-13-2010, 01:20 PM   #1
Stragonian
Member
 
Registered: Dec 2003
Location: Indiana
Distribution: Slackware & PassionX
Posts: 77

Rep: Reputation: 34
Open Office year-to-date column


I don't use office apps often and I'm using Open Office to put donations entries into a yearly statement for a non profit organization, and I can't figure out how to do a year-to-date column that will sum each line to the lines before it.

Entry⠀⠀⠀⠀Amount⠀⠀⠀⠀Year to Date
Entry 1⠀⠀⠀$20.00⠀⠀⠀⠀⠀$20.00
Entry 2⠀⠀⠀$10.00⠀⠀⠀⠀⠀$30.00
Entry 3⠀⠀⠀$50.00⠀⠀⠀⠀⠀$80.00
ect ...

How would I accomplish the year-to-date column using a formula, to add the previous year to date and the amount.
 
Old 04-13-2010, 01:36 PM   #2
H_TeXMeX_H
LQ Guru
 
Registered: Oct 2005
Location: $RANDOM
Distribution: slackware64
Posts: 12,928
Blog Entries: 2

Rep: Reputation: 1292Reputation: 1292Reputation: 1292Reputation: 1292Reputation: 1292Reputation: 1292Reputation: 1292Reputation: 1292Reputation: 1292
You should use something like:

Code:
=sum($B$2:B2)
for the first year to date ($20), then double click the lower right corner of the box to fill the others in, I tried it and I got:

Code:
year	amount	year to date
year 1	$20.00	$20.00
year 2	$10.00	$30.00
year 3	$50.00	$80.00
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
nautilus: changing the appearance of the 'date modified' column? apeekaboo Linux - Software 1 09-23-2011 04:36 AM
Changing the default date format for Open Office.org pwabrahams Linux - Software 6 09-26-2010 10:05 PM
Office Suite of the Year jeremy 2008 LinuxQuestions.org Members Choice Awards 72 02-22-2009 11:39 AM
date shortcut in open office alan_h404 Linux - Desktop 0 10-18-2006 05:07 PM
remove 'modified date' column in nautilus list view nexx_au Linux - Software 0 12-09-2003 04:29 AM

LinuxQuestions.org > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 10:33 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration