DCOUNTA Function

The DCOUNTA function is used to find the count of items from a table/database range, based on the given condition.
Note: Unlike DCOUNT function, this counts values and texts. However, blank cells are ignored.


==DCOUNTA(Database Range, Field Name, Criteria Range)
Whereas DatabaseRange is the entire table/database (including the title), FieldName is the field for which the count has to be taken and CriteriaRange is the name of the FieldName.

Video Tutorial:

Let us find the count of items from the table/database, using DCOUNTA function, with the help of the below video.

Learn MS Excel

Ask Questions

Ask Question