5

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 ?

5

I managed to find the syntax that works, but I was not allowed to post the answer. It should look like this:

=COUNTIF(Table 1 :: B2:B337;"="&T(A3))
  • 1
    Very important piece of information that is still not really documented in the Numbers help! Note, however, that (at least with Numbers 4.x) the T() function around the cell reference has to be omitted. It now works with: =COUNTIF(Table 1 :: B2:B337;"="&A3)) – Daniel Nov 9 '17 at 15:27
1

Seems like you are using wrong argument in condition part of formula - meaning that you should put there string that you are looking for not the address of the cell because Numbers thinks that you are looking for string "C9" and not value from C9.

  • Hey thanks for the input: I managed to find the syntax that works, but I was not allowed to post the answer. It should look like this: =COUNTIF(Table 1 :: B2:B337;"="&T(A3)) – FFrewin Mar 3 '14 at 23:58
0
simply =COUNTIF(table1 :: B5:B7; C9 )

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .