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.
Let us find the count of items from the table/database, using DCOUNTA function, with the help of the below video.