Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in /home/myscript/public_html/classes/classdb.php on line 42 DCOUNTA Function / Formula in Microsoft Excel 2007 | Video Tutorial
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.