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.

Micah Soto

Update 19 May 2020

You should read it

May be interested

Function Address - The function returns the address of a cell in Excel (usage, examples, examples)
the following article dexterity software will introduce readers to the address function one of the most popular reference and lookup functions in excel.
FIND function in Excel - Usage and examples
find function in excel - usage and examples. the find function in excel is a function of the text function group, you can use the find function to find the position of a substring of text in another text. to understand more about the find function, how to use it and the examples used in the find function
Match function in Excel - Usage and illustrative examples
the match function in excel finds a specified item in a specified range and, returns the relative position of that value in this range. function syntax and usage syntax: = match (lookup_value, lookup_array, [match_type]). in which: - match: is the function name. - lookup_value: is the value to search, be it text or numeric.
ROUNDUP function in Excel - Usage and examples
today, the software tips will guide you how to use the roundup function to round numbers (rounding up) in excel. roundup function structure function syntax: = roundup (number, num_digits). in which: + roundup: is the function name. + number: is the number to be rounded up. + num_digits: is the number of digits after the comma you want to round. for example:
DSUM function in Excel, how to use DSUM function and examples
dsum function in excel, how to use dsum function and examples. the dsum function in excel is a fairly common function with a fairly simple usage. but if you do not know how to use the dsum function, you can refer to the following article to understand h
RANK function - Rank function in Excel - Usage and examples
the rank function arranges equal numbers of the same rank. however, the duplication will affect the ranking of subsequent numbers. for example, you have the sequence number: 1,2,2,3,4 and are arranged in ascending order, so the order of the number 1 in the series is 5.
The search function satisfies many conditions in Excel - Usage and examples
the search function satisfies many conditions in excel - usage and examples. in the process of processing data in excel many times you need to search for data that satisfies many conditions to extract data, so you are looking for a function that satisfies many things.
INDIRECT function in Excel - How to use INDIRECT function and examples using INDIRECT function
indirect function in excel - how to use indirect function and examples using indirect function. you want to refer to a range of data without changing the formula in the cell. the following article introduces you to the indirect function in excel to help you reference
Instructions for using the COUNTBLANK function in Excel
in excel, the countblank function helps users count the number of blank cells in a given data range. this function is useful in checking for missing data, processing reports and statistics. this article will guide you in detail on how to use countblank, with practical examples.
Multiple if function - Usage and examples
the following article gives you a detailed guide on how to use the multiple if function with examples. the if function is simplified in the sense that the function tests a value with a given condition, if it satisfies the condition that returns 1 value, if it does not satisfy the condition.