Countif formula does not work as expected

[Fagun Shah]

This your example -

I copypasted it in pabbly Number Formatter -> Spreadsheet Formula-

As you can see it is not working as expected.

And my other question is can we pass google sheet get rows array response in countif formula?

 

[Fagun Shah]

@Pabbly these formulas also does not work -