Review your favorite Linux distribution.
Go Back > Forums > Linux Forums > Linux - Software
User Name
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.


  Search this Thread
Old 05-01-2009, 08:24 AM   #1
Registered: Jun 2005
Location: Kentucky
Distribution: Debian
Posts: 794

Rep: Reputation: 56
OpenOffice Spreadsheet - Total All "Numerical" Values in a Column

I recently bought a new computer that shipped with Window$ Vista on it, so I used it for a little while just to see what it was all about. Then I heard Ubuntu was releasing a new version and I backed up all my documents and installed it, and I'm quite pleased and plan on keeping it as my permanent OS. However, I have an issue. I use a spreadsheet to manage my checking account, every deposit or withdrawal all the way from a stick of gum to paying the rent gets tracked on this thing, and I have a sheet for each month to kind of help with organization. At the top right of the sheet, to the right of all my normal columns, I put two cells labeled "Total Withdrawals" and "Total Deposits" that automatically update to show me at a glance my total withdrawals and total deposits for the month so I can make sure that I keep my input greater than my output. In MS Excel, the formula "=SUM(B:B)" set the value of the cell to the total of all numerical values in column B. This formula doesn't work however in OpenOffice. The first cell of column B is the label "Withdrawal Amount", so I just want it to total all of the numerical value cells in column B. Anybody know what formula I would use for this in OpenOffice?
Old 05-01-2009, 09:21 AM   #2
Registered: Feb 2006
Distribution: Debian Sid
Posts: 792

Rep: Reputation: 331Reputation: 331Reputation: 331Reputation: 331
"=sum(a1:a5)" works in v3.0.1 including using a 0 for labels.

Try inserting a function from the menu: Insert->Function->sum->next, then click on the sreadsheet icon to the right of "number 1" and highlight the range you want to sum.


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
"substraction" and "division" function in OpenOffice Calc mac1234mac Linux - Software 7 12-03-2009 06:36 AM
Collection Values of "ps" command CPU column scbops Programming 13 01-07-2009 01:50 AM
OpenOffice - How to "columnize" a printout in Spreadsheet? SlowCoder Linux - Software 1 02-12-2008 11:07 AM
cups-lpd: "Numerical result out of range" ramz Linux - General 2 07-27-2006 09:46 AM
LXer: IBM, Sun (and OpenOffice!) Say "No Way" to VNUnet Control Story LXer Syndicated Linux News 0 02-09-2006 03:01 AM > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 12:28 AM.

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