Syntax for column sum in table?

maxqnz · Last edited by maxqnz on Sun Oct 05, 2003 7:33 pm; edited 1 time in total

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

The Liquidator · Posted: Sun Oct 05, 2003 3:00 pm Post subject:

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

maxqnz · Posted: Sun Oct 05, 2003 3:20 pm Post subject:

maxqnz · Posted: Sun Oct 05, 2003 7:48 pm Post subject:

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