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

Margin appeared for no reason

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


Joined: 28 Jul 2004
Posts: 35
Location: Melbourne, Australia

PostPosted: Sun Sep 05, 2004 5:01 am    Post subject: Margin appeared for no reason Reply with quote

Can someone please tell me how to add a column of figures in which there are some blank spaces. I tried but was only successful in adding together the cells down to the blank one. The ones with figures in below the blank one were ignored.

Stuartp77
_________________
Stuartp77
Back to top
View user's profile Send private message
David
Super User
Super User


Joined: 24 Oct 2003
Posts: 5668
Location: Canada

PostPosted: Sun Sep 05, 2004 1:06 pm    Post subject: Re: Margin appeared for no reason Reply with quote

stuartp77 wrote:
Can someone please tell me how to add a column of figures in which there are some blank spaces. I tried but was only successful in adding together the cells down to the blank one. The ones with figures in below the blank one were ignored.

Stuartp77


Type in the formula; don't rely on the Sigma summation icon to do the work. If you have data in cells from A1 to A10, with some missing, still type =SUM(A1:A10) for your formula.

David.
Back to top
View user's profile Send private message
stuartp77
General User
General User


Joined: 28 Jul 2004
Posts: 35
Location: Melbourne, Australia

PostPosted: Mon Sep 06, 2004 4:42 am    Post subject: Adding column of figures with blank cells Reply with quote

Thank you David for your help.

That little piece of information re adding column of figures including blank cells has helped my tremendously.

Much obliged to you. (You probably noticed I had the wrong heading).

Best regards,

Stuart.
_________________
Stuartp77
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