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? -- Regards, Rick Barnes www.nostabo.net ******************************************************************* PRIVILEGED - PRIVATE AND CONFIDENTIAL This electronic mail is solely for the use of the addressee and may contain information which is confidential or privileged. If you receive this electronic mail in error, please delete it from your system immediately and notify the sender by electronic mail or using any of the contact details noted herein. This e-mail sent via Evolution 2.0.4 running on a Linux 2.6.11 kernel.
signature.asc
Description: This is a digitally signed message part
