How to write AND condition in Numbers
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")