Rick Barnes wrote:
On Sat, 2005-04-16 at 11:34 +1200, Ian Laurenson wrote:
On Sat, 2005-04-16 at 10:19, Rick Barnes wrote:
[snip]
Probably not...to many, and it may seem trivial. But if cells A1 through
E1 each contain the value 1:
1) =A1:E1 returns 1
2) =A1+B1+C1+D1+E1 returns 5
3) =SUM(A1:E1) returns 5
Example number one "appears" to be a formula, and it is, though not
correct.[remainder snipped]
Although it could be if it was entered as an array formula
(Control+Shift+Enter).
Thanks, Ian
True, but that would produce results in 5 cells, each corresponding to
one of the cells in the array. The point of this example is to create
one cell with the sum of all of the 5 cells.
So now after all of the posts, can everyone see why this topic is so
misunderstood and divisive, and in need of explanation?
I think, though, in a introductory Calc document, this is going to
confuse more than it will help.
--
Peter Kupfer -- Using OOo since 'OO4
[EMAIL PROTECTED]
