Hi, Which version of POI is this? Can you try with the latest release 3.16? There have been fixes in this area, especially https://bz.apache.org/bugzilla/show_bug.cgi?id=56822 seems to be related.
Dominik. On Wed, May 3, 2017 at 3:27 PM, Pierre MIEHE <miehe.pie...@gmail.com> wrote: > Dear all, > > I am currently using the NPOI version of POI for C#, and I have a doubt > about the countifs and sumifs function: it seems they give wrong results no? > I looked at the code on http://www.lookatsrc.com/source/org/apache/poi/ss/ > formula/functions/Countifs.java?a=org.apache.poi:poi > and I have indeed the impression it takes the minimum value of countif for > the couples of parameters, instead of applying an "and" to each cell; did I > get something wrong? > > Thank you in advance for your help and best wishes, > > Pierre > > > > --- > L'absence de virus dans ce courrier électronique a été vérifiée par le > logiciel antivirus Avast. > https://www.avast.com/antivirus > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: user-unsubscr...@poi.apache.org > For additional commands, e-mail: user-h...@poi.apache.org > >
