The Dcount function in Microsoft Excel is used to count the cells that contain numbers in a column of records in a database that matches conditions that you specify. Do you want to know how you can use the Dcount function in an Excel worksheet? Here are the steps to do so.
- Open the desired Excel worksheet, select the cell where you want to get the result of the function, click on the Insert Function button in the search for a function box, type Dcount, and then click on the go button.
- Select Dcount from the list, and then click on the OK button.
- Click on the database box, and then select the range of cells containing the database, which, for example, includes the name of product place quantity and price here.
- Click on the field box, and then select the field range, which for demo purpose here is the price. Click on the criteria box and then select the criteria range that contains the condition you specify which for example here is USB. It is also showing the results here.
- Click on OK to get the result. That is the total number of cells that contain numerical data. If you type text instead of numeric in any of the cells, the result will change. See, that wasn’t hard at all.