| View previous topic :: View next topic |
| Author |
Message |
bobcox
Newbie
Joined: 04 Jun 2011
Posts: 4
Location: Illinois
|
 Posted: Sun Jun 17, 2012 8:46 am Post subject: Sum nonzero values on a dynamic range |
 |
|
| 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 |
|
 |
scsisys
OOo Enthusiast
Joined: 17 Dec 2009
Posts: 172
|
| Posted: Sun Jun 17, 2012 10:06 am Post subject: |
|
|
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 |
|
|
|
