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

I am unable to extract the ods file from the archive. Since ods files are zip archives themselves there is 
little point in zipping them again.

The expression inthe error message differs greatly from the one mentioned earlier. Please be sure to give the 
cell address that contains the problem.


A J Guelzow

On 2011-10-23, at 4:39, fellowsgarden gmail com wrote:

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

I also encountered the following error message:

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

Thanks for your help!


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