I am struggling to come with a solution on this problem, making me wonder if the Countif function is designed to work this way, or what is wrong with my syntax at the end.
I have my first table with the data and the second where I want to count data. In the second table I have columns with the "strings", which their appearance I want to count on my first table. My formulas is the following:
=COUNTIF(table1 :: B5:B7;"=T(C9)")
I have tried also
=COUNTIF(table1 :: B5:B7;"=C9")
But I am getting syntax error. Can someone give some insight ?