I think I figure it out in a way. My usage of CountIf is not correct. It should be:
=CountIf(C$1:C1, "?")
Where the second the filter to be matched not condition with true of false result.
Still I don't know if there is Val2 Excel similar function in Numbers.