The formula of the Dcount function is [=Dcount(database,field,criteria)]. Its function is to return the number of cells in the data column that meet the specified conditions and contain numbers. The parameter database represents the cell range.

#1. The function of Dcount function: Return the number of cells in the data column that meet the specified conditions and contain numbers (as shown in the figure);

2. The formula of Dcount function: =Dcount(database,field,criteria), database represents the cell range, field represents the data column of the operation, and criteria represents the cell range containing the conditions ( As shown in the picture);

3. The following sample data (as shown in the picture);,

4, E1:E2 It is a conditional cell range. The following is to find out how many quantity cells there are with unit price > 20 (as shown in the picture);

5. Enter the formula =DCOUNT( in the cell A1:C6,"Quantity",E1:E2) (as shown in the picture);

6. Click the enter key to display data 3, which indicates the quantity unit with a unit price greater than 20 There are 3 grids (as shown in the picture).

Recommended tutorial: "excel tutorial"

The above is the detailed content of dcount function usage. For more information, please follow other related articles on the PHP Chinese website!