MS Excel Dcounta Formula



DCOUNTA formula in Excel Counts the nonblank cells in a field (column) of records in a list or database that match conditions that you specify.

The field argument is optional. If field is omitted, DCOUNTA counts all records in the database that match the criteria.

How to use Dcounta Formula

DCOUNTA(database,field,criteria)

Database is the range of cells that makes up the list or database. A database is a list of related data in which rows of related information are records, and…

3 thoughts on “MS Excel Dcounta Formula

  1. Sir,

    As i was going through your this above video tutorial, i didn't feel that the example is appropriate. As i have understand that "d" means to put a condition and "counta" counts the number of cells which are not empty, so if use "dcounta" in text as per your above example then why would it will going to read and empty cell because in above video we have already given an condition to it that it should be "above 9". So there is no use of "dcounta" fucntion because if we put the "dcount" in the above example then it will also give the same result.

    If it just for an understanding point of view then its ok .

    please correct me if i am wrong.

    Thanks and Regards,
    Subashish Khanka

Leave a Reply

Your email address will not be published. Required fields are marked *