On Sat, 2009-03-21 at 17:19 -0600, Rita & Klaus Kuhnlein wrote: > Sorry, > > the Gnumeric Help says that SUM-Function is Excel compatible. And > Excel declares the Komma as an operator and not as a delimeter of two > arguments. A Komma is a set union operator and a Blank is a > intersection operator. It is not an excuse for Gnumeric when Excel > makes an error. Gnumeric is better than Excel (hopefully)! >
But the comma is also an argument separator. With the parentheses you are using you have passed two arguments to the SUM function rather than applied the comma operator. If you want to use the comma operator you need to put in the correct parentheses: SUM(A1:A2,A2:A3) here the comma is an argument separator SUM((A1:A2,A2:A3)) here the comma is a union operator In Excel you will find a difference between those two expressions. In Gnumeric the comma operator has some known bugs. Of course this has nothing to do with whether the SUM function is Excel compatible or not. It is the comma operator (when used) that is the problem. In your formula you didn't use it though. Andreas -- Andreas J. Guelzow <aguel...@pyrshep.ca> _______________________________________________ gnumeric-list mailing list gnumeric-list@gnome.org http://mail.gnome.org/mailman/listinfo/gnumeric-list