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

Sum nonzero values on a dynamic range

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


Joined: 04 Jun 2011
Posts: 4
Location: Illinois

PostPosted: Sun Jun 17, 2012 8:46 am    Post subject: Sum nonzero values on a dynamic range Reply with quote

I have a personal accounting sheet which includes expenses categorized by an account code in column e. I would like to obtain a sum of values of a range, typically from January, 1 of the current year to the last entered data field in J column. When I use =sum($j$4204;$j44440) I get a much smaller value than I know exists.
Back to top
View user's profile Send private message
scsisys
OOo Advocate
OOo Advocate


Joined: 17 Dec 2009
Posts: 248

PostPosted: Sun Jun 17, 2012 10:06 am    Post subject: Reply with quote

Based on your formula, you are only summing two cells; $j$4202 and $j44440 .
If you are intending to sum all cells from, and including, 4202 to 44440, then replace the ; with a : and that should take care of the problem.

scsisys
_________________
OO 3.2.1
Win XP /SP3
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