COUNTIF returns #VALUE! while negative criteria

Apr 20, 2016 at 10:35 AM

I'm using EPPlus.dll version to insert some data into existing excel worksheet. In the worksheet, the are some predefined formulas, which work with inserted data. Directly in MS Excel 2007 all works fine (all formulas are recalculated), but it seems that COUNTIF formula is not working after Calculate command in EPPlus.

The COUNTIF formula doesn't work only if the criteria is a negative number, then the COUNTIF returns #VALUE!

Input range for COUNTIF is generated by another formula (some nested IFs).

Has anyone else experienced this weird behaviour? Is there some workaround which can be used?


P. S. Is here some option to append XLSS file as an example?