How to write AND condition in Numbers I have a dataset where I want to write a COUNTIFstatement in Numbers (Mavericks). Specifically I want to count if a number is between 16 and 30.

So far I have tried: COUNTIF(test-array, "&gt;15 AND &gt;= 30") with no luck.

Reading from the documentation:


  condition: An expression that results in a boolean value of TRUE or FALSE. A condition can contain anything as long as the result from comparing it to a value in test-values can be expressed as TRUE or FALSE.


But I cannot find the correct logical and operator for the condition (tried &amp;&amp;).
If you don't mind a separate column/table for this, you can check if each cell is between 16 and 31 like this:



Table 2, A1:

IF(x::A1&gt;15,IF(x::A1&lt;31,TRUE,FALSE))


Table 2, A9:

COUNTIF(A,"=TRUE")