DCOUNTA
DCOUNTA counts nonblank cells containing numbers or text that meet the specified criteria.
=DCOUNTA(database,field,criteria)
The DCOUNTA function operates just as the DCOUNT function, however, it counts the number of cells containing numbers or text. If you have a database that has values stored as numbers and cells stored with text, you might need this function to count both storage types. The database is the cell reference range or named range of the database; and the field is referenced as the column number from left to right. The criteria is a range that is referenced and the function operates from the parameters set.