Ralph Shumaker wrote: > John Machin wrote: >> Ralph Shumaker wrote: >> >>> John Machin wrote: >>> >>>> Secondly, you don't need sum(En-Fn) ... just En-Fn is enough. >>>> >>> En-Fn will give you the difference. sum(En-Fn) is different. >> >> Where x is a scalar, how can sum(x) differ from x? >> > > In gnumeric 1.6.3: > A1 5 > B1 7 > C1 =sum(A1-B1)
Well my (Windows) Gnumeric 1.6.3 produces -2, as do (a) Excel (b) common sense > shows 12 > A2 5 > B2 7 > C2 =A1-B1 > shows -2 > > I used what Fred wrote. And what you wrote appeared to me to be > different from what I wrote. And gnumeric seems to bear me out. > > > _______________________________________________ gnumeric-list mailing list [email protected] http://mail.gnome.org/mailman/listinfo/gnumeric-list
