DCOUNT function in Excel - Usage and practical examples

The DCOUNTA function is one of many frequently used math functions in Excel. To better understand this function, let's follow the following article of TipsMake.com .

DCOUNT function in Excel - Usage and practical examples Picture 1

1. Use of the DCOUNT function

The DCOUNT function as you can see has the word COUNT in the function name, so this is a function line to count.

The DCOUNT function helps you count non-blank data cells in list columns or data arrays with defined conditions.

2. Usage of the DCOUNT function

Formula: = DCOUNT (array of data to consider; specify column used in the array; range of cells containing the conditions)

Inside:

Your data array to consider should include a header for each column of data.

Specify the column used in the array so that the function can identify the column that retrieves the data, you can use the column heading or number the columns in the array from left to right.

The range of cells that contain conditions to determine counting conditions.

3. Example of DCOUNT function

We have an example of a price list for different phone lines. In this price list there are a number of phone lines that will be discounted at different rates. We cannot use the regular counting function, which requires DCOUNTA.

The calculation formula given here is: = DCOUNTA (A1: D6; 4; B9: B10)

With A1: D6 as the data array we need to look for information in it to count out the values ​​that match the condition.

The number 4 corresponding to column number 4 in the data array A1: D6 is also the Notes column in the array.

And finally, the necessary condition B9: B10 , the condition column corresponding to the value to consider needs to have the same title as the column used in the array.

With the word Reduce * we can count the data cells with the word Reduce as the * symbol replace all any other characters.

DCOUNT function in Excel - Usage and practical examples Picture 2

Finally, the result you get is 4 data boxes containing the word Reduce at the top. Because this is a small example, you can count with your eyes to see that the calculation has done exactly its effect: there are 4 data cells containing the word Discount.

DCOUNT function in Excel - Usage and practical examples Picture 3

Thank you for following the article about the DCOUNT function in Excel and how to use the DCOUNT function of TipsMake.com . Hope you can master the DCOUNT function in real applications.