DCOUNT

Syntax:

DCOUNT( range, condition )

Returns the number of number cells in the range for which the corresponding condition is satisfied.

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.