6

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 ?

Improve this question

3 Answers 3

Reset to default
7

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))
Improve this answer
1
  • 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
    Commented Nov 9, 2017 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.

Improve this answer
1
  • 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
    Commented Mar 3, 2014 at 23:58
0 
simply =COUNTIF(table1 :: B5:B7; C9 )
Improve this answer

You must log in to answer this question.

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