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:
The following crashes:
The error message is: Index was outside the bounds of the array. Cells version is 18.104.22.168 for .NET.
Can you please let me know if this is a bug or something wrong with my spreadsheet.
We have found and fixed this bug. Please try this attached version.
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.
Thanks for considering Aspose.
Could you try the fix attached by Laurence in this thread.