Excel Function : DCOUNTA

Download now!

Excel Function : DCOUNTA




Counts nonblank cells in a database

Microsoft Excel Reference Page


Syntax and Description of the DCOUNTA Excel Function

return value I'm trying to get the syntax for DCOUNTA function to return a value in a excel spreadsheet. A: =DCOUNTA(A:A, "*Things*") Will return the number of cells in column A that contain the word "Things". Replace "Things" with what you want to count.

About DCOUNTA Excel Function

The DCOUNTA function in Excel counts the number of cells in a range that contain numbers and meet a given criteria. The syntax of the DCOUNTA function is as follows: DCOUNTA(range, criteria) where "range" is the range of cells that you want to count and "criteria" is the criteria that the cells must meet in order to be counted.