Free Support Forum - aspose.com

Possible bug in COUNTIF function

Hello,

I have a spreadsheet where the COUNTIF function crashes on Calculate if the second parameter (ie the criteria) is an empty string, i.e. double quotes ("").

The following works:
COUNTIF(A1:A5, “abc”)

The following crashes:
COUNTIF(A1:A5, “”)

The error message is: Index was outside the bounds of the array. Cells version is 4.4.0.5 for .NET.

Can you please let me know if this is a bug or something wrong with my spreadsheet.

Thank you.

We have found and fixed this bug. Please try this attached version.

Hi Laurence,

Yes that fixed it.

Thanks for the quick response!

I am encountering the same bug with COUNTIF formula. Can you send me the solution? Thank you.

Hi sarah56565,

Thanks for considering Aspose.

Could you try the fix attached by Laurence in this thread.

Thank you.