On 26/03/2006, at 7:11 PM, John Jason Jordan wrote:
On Sat, 25 Mar 2006 22:23:06 -0800
John Jason Jordan <[EMAIL PROTECTED]> dijo:
OK, this is ridiculous.I have spent hours on this five-page Writer
document and can't get the formulas to work at all. Part of the
problem is that I can't find any documentation. Where is the Help
file for formula syntax? Like, if I want to sum cells C2 through
C6, and C8 through C11, and C15 through C25, how do I write that?
No matter what I do I get bizarre results. No error messages, just
the wrong totals. There must be something fundamentally wrong. I've
asked three times hear and got only one reply. I have to send this
off tomorrow and I have no more time left to fiddle with it.
Someone please HELP!
Hi John,
There is one important rule here - you can only sum contiguous cells.
Non-contiguous cells you have to add up. However you can join these
two sets together without issue. So the solution for your above
formula would be:
=SUM(<C2:C6>)+SUM(<C8:C11>)+SUM(<C15:C25>)
Regards
Jonathon
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
