Re: sumproduct with "names" // fine in libreoffice, #VALUE! warning in gnumeric



Please provide a sample file. It works for the examples I made up.

Andreas

A J Guelzow


On 2011-10-23, at 3:12, fellowsgarden 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, <fellowsgarden 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


[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]