Spreadsheet formula COUNTIF not behaving as described in your doc

[Andreas]

I copied
COUNTIF(['Caen', 'Melbourne', 'Palo Alto', 'Singapore'], 'a')
from your docs & got
****
Type spreadsheetFormula
Result 0
****

According to your doc Result should be 3.
Am I doing something wrong?

 

[Fagun Shah]

I copied
COUNTIF(['Caen', 'Melbourne', 'Palo Alto', 'Singapore'], 'a')
from your docs & got
****
Type spreadsheetFormula
Result 0
****

According to your doc Result should be 3.
Am I doing something wrong?

Already reported- https://forum.pabbly.com/threads/countif-formula-does-not-work-as-expected.648/

They are working on it

 

[Andreas]

Thank you very much!