Spreadsheet formula COUNTIF not behaving as described in your doc

Status: Closed · Asked by Andreas on May 28, 2021 · 0 views

Andreas — Question · May 28, 2021

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?

Attachments

Fagun Shah — Reply · May 28, 2021

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

Fagun Shah
- Automation Freelancer
- Let's Connect - https://www.facebook.com/fagun.shah.7/

Andreas — Reply · May 28, 2021

Thank you very much!

Back to all forum threads · Log in to reply