Home > Articles > Home & Office Computing > Microsoft Applications

  • Print
  • + Share This
This chapter is from the book

DCOUNT

DCOUNT counts the number of cells containing numbers that meet the specified criteria.

=DCOUNT(database,field,criteria)

The DCOUNT function tallies the number of cells containing numbers. Cells that contain text and blank cells are ignored. To include text cells, use DCOUNTA (see upcoming section). If you have a list or database, the database can be referenced as a cell reference or as a named range. The field is the number of the column in the database from left to right or the column heading in quotes (not case sensitive). The criteria is a range that contains the constraints the function operates from. For example, let's say you had a large database that had several blank cells as well as cells containing numbers, only some of which you were interested in. The criteria could specify to count all numbers having a value of more than 4,000 and less than 7,000, as shown in the third example in Figure 3.2. The criteria range is C20:C22, the field reference is left blank so that the function searches the entire list (C5:F9).

Figure 3.2 The DCOUNT function counts the number of cells containing numbers.

  • + Share This
  • 🔖 Save To Your Account