Indeed the code in the link you sent is corrected, so this is just a version problem.
Thank you! Pierre -----Message d'origine----- De : Dominik Stadler [mailto:dominik.stad...@gmx.at] Envoyé : mercredi 3 mai 2017 20:58 À : POI Users List <user@poi.apache.org> Objet : Re: Error in Sumifs/countifs functions? 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 > > --- 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