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

Syntax for column sum in table?

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Writer
View previous topic :: View next topic  
Author Message
maxqnz
Super User
Super User


Joined: 24 Mar 2003
Posts: 1290
Location: Te Ika a Maui, Aotearoa

PostPosted: Sun Oct 05, 2003 1:54 pm    Post subject: Syntax for column sum in table? Reply with quote

Here's the table I'm working on:
http://maxqnz.com/tablesum.jpg

Here's my problem:

Pressing the sum button only sums up the nearest block of non-blank cells, in this case the cells listed in the shot. If I enter the formula "=sum(d2:d21)" the syntax used in Calc, I get "The expression is faulty" What syntax do I need to use to get Writer to include cells that are currently empty in its Sum function? Do I have to manually add each cell, (<d2>|<d3>|<d4>, etc.)?
_________________
Noho ora mai, ka kite ano.
What Is A Pieriansipist?

OOo 2.4/XP Pro SP2 / OOo 2.3.0.1/OpenSuse 10.3


Last edited by maxqnz on Sun Oct 05, 2003 7:33 pm; edited 1 time in total
Back to top
View user's profile Send private message Visit poster's website
The Liquidator
Super User
Super User


Joined: 27 Feb 2003
Posts: 1368
Location: Manchester, UK

PostPosted: Sun Oct 05, 2003 3:00 pm    Post subject: Reply with quote

Hi

Select the "autosum" icon. Then with the left mouse button pressed, drag the cursor down the entire column you want to add up. Those to be included will be highlighted in black.

Select the "tick" and it's done.

Ian
Back to top
View user's profile Send private message
maxqnz
Super User
Super User


Joined: 24 Mar 2003
Posts: 1290
Location: Te Ika a Maui, Aotearoa

PostPosted: Sun Oct 05, 2003 3:20 pm    Post subject: Reply with quote

The Liquidator wrote:
Hi

Select the "autosum" icon. Then with the left mouse button pressed, drag the cursor down the entire column you want to add up. Those to be included will be highlighted in black.

Select the "tick" and it's done.

Ian


Great, thanks that did it.
_________________
Noho ora mai, ka kite ano.
What Is A Pieriansipist?

OOo 2.4/XP Pro SP2 / OOo 2.3.0.1/OpenSuse 10.3
Back to top
View user's profile Send private message Visit poster's website
maxqnz
Super User
Super User


Joined: 24 Mar 2003
Posts: 1290
Location: Te Ika a Maui, Aotearoa

PostPosted: Sun Oct 05, 2003 7:48 pm    Post subject: Reply with quote

It turns out that all I was doing was wrong was using the parentheses - "=sum(d1:d21)" is invalid, but "=sum<d1:d21>" works fine. A handy thing to know, since I prefer not to use my mouse more than I must.
_________________
Noho ora mai, ka kite ano.
What Is A Pieriansipist?

OOo 2.4/XP Pro SP2 / OOo 2.3.0.1/OpenSuse 10.3
Back to top
View user's profile Send private message Visit poster's website
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Writer 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