Countifs fail to evaluate correctly

[jamstar9506]

I am using NPOI 2.5.5 and found that using countifs in a cell, and evaluating the cell, I receive back the result of the lowest count matching criteria.

The following formulas evaluate to the same value when they should not as they get progressively more restrictive.

=COUNTIFS(Data!AL:AL,">0",Data!J:J,D3)
=COUNTIFS(Data!AM:AM,">0",Data!AL:AL,0,Data!J:J,D3)
=COUNTIFS(Data!AM:AM,0,Data!AL:AL,">0",Data!J:J,D3)

This is not the expected outcome countifs in Excel as they do evaluate differently when opened in excel.

https://github.com/nissl-lab/npoi/blob/master/main/SS/Formula/Functions/Countifs.cs

I checked the formula definition and found that it runs a countif with the each set of arguments and compares the value to see what one is smaller and tracks that. It will need to run a countif but track what rows are counted then only check those rows for the next arguments.

Please let me know if I can provide any other information.

[tonyqus]

I checked the formula definition from Microsoft document. Your concern makes sense.

Are you willing to create a PR to correct the logic of countifs?

[jamstar9506]

Hi tonyqus,

I have been busy but I should have some time to do it now. Do you have any insights on how to best accomplish this, or should I just go for it?