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.