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
