Countif formula does not work as expected

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

@Pabbly these formulas also does not work -