Please provide a sample file. It works for the examples I made up. Andreas
A J Guelzow On 2011-10-23, at 3:12, fellowsgar...@gmail.com wrote: > PS: expenses, therefore amount_temp<0, as the column also contains income... > > Harry > > On Sun, Oct 23, 2011 at 11:07 AM, <fellowsgar...@gmail.com> wrote: > Hello! > > I just installed gnumeric (on ubuntu) for the first time and tried to open a > document from libreoffice calc. > > Gnumeric returns an error message for this field, when opening the document: > > =sumproduct((item_temp<>"rent")*(amount_temp<0)*amount_temp) > > The cell shows the #VALUE! warning. > > Both in openoffice / libreoffice this works, and is supposed to return the > sum of all expenses _excluding_ rent (which it does, in oo & libreoffice). > > Gnumeric does recognize the sumproduct function. It, too, recognizes the > "names" I defined (it shows a rectangle around them, resp., when I F2 the > problematic field). > > I hope you have an idea :) > > Harry > > _______________________________________________ > gnumeric-list mailing list > gnumeric-list@gnome.org > http://mail.gnome.org/mailman/listinfo/gnumeric-list
_______________________________________________ gnumeric-list mailing list gnumeric-list@gnome.org http://mail.gnome.org/mailman/listinfo/gnumeric-list
