Possible bug in COUNTIF function

tcnz · November 25, 2007, 10:52pm

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.

Laurence · November 25, 2007, 11:23pm

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

tcnz · November 25, 2007, 11:39pm

Hi Laurence,

Yes that fixed it.

Thanks for the quick response!

sarah56565 · June 6, 2008, 1:52pm

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

amjad.sahi · June 7, 2008, 12:39am

Hi sarah56565,

Thanks for considering Aspose.

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

Thank you.