DCOUNT

Syntax:

DCOUNT(range, condition)

Returns the number of cells in the range whose contents meet the condition specified.

Note that this function will only count cells which contain a numeric value or a formula evaluating to a numeric value.

It is often more useful to use DCOUNTA as this does not impose the requirement that the cells in the range are numeric.

Example:

DCOUNT(A1:A25, A1:A25>=18)

returns the number of cells whose value is greater than or equal to 18.

See DAVG for more examples of how to use the condition to control which cells are counted.