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



Attached please find a sample file (to unzip just type gnumeric).

I also encountered the following error message:

Sheet1!L17
Unable to parse 'SUMPRODUCT(item_temp=NOT(#name?$e9);amount_temp<"0";amount_temp)' ('Invalid _expression_')

Thanks for your help!

Harry

Attachment: gnu_x.ods.zip
Description: Zip archive



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