Result of COUNT function is incorrect

Posted by: yyoshimura on 8 March 2021, 5:02 pm EST

  • Posted 8 March 2021, 5:02 pm EST


    The result of COUNT function is not correct with following formula. Please refer attachment for reproduction. B3 cell is the result using Excel which value is 2, B6 cell is the result using library which value is 1.


    If we defined the COUNT function without the last comma, the result will be the same.

    We hope that the formula result should be same as Excel. The problem only occurs with COUNT function. COUNTA is working as expected.

    By the way, we are using the latest V4.0.4.

  • Replied 9 March 2021, 10:12 pm EST


    Thank you for bringing this to our attention.
    We have forwarded this to the developers and will let you know as soon as we get the update from their end.
    [Internal Tracking ID: 3841]

    Prabhat Sharma.
  • Marked as Answer

    Replied 10 April 2021, 11:54 pm EST


    We are happy to inform you that the issue has been fixed in the latest build 4.0.5 and you can update it from the given link:

    Prabhat Sharma.
  • Replied 12 April 2021, 10:44 am EST

    We confirmed that this issue is fixed in the latest build. Thank you for your support.
Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels