Posted 8 March 2021, 5:02 pm ESTHi
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.