Syntax:
DCOUNTA(range, condition)
Returns the number of cells in the range for which the corresponding condition is satisfied.
This function can be used with all cells, including those containing text strings and other non-numeric data.
Example:
DCOUNTA(A1:A25, A1:A25="C^#")
will give you the number of cells whose contents begin with the letter C
.
See DAVG
for more examples of how to use the condition to control which cells are counted.