Excel Function : DCOUNTA
Counts nonblank cells in a database
Microsoft Excel Reference Page
Syntax and Description of the DCOUNTA Excel Function
I'm trying to get the syntax for DCOUNTA function to return a value in a excel spreadsheet.
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.