Syntax:
DCOUNTA(range, condition)
Returns the number of cells in the range whose contents satisfy the specified condition.
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.