Skip to content

Formulas to Count Items in a List in Excel!

Listen to this article

If you have a list of data with duplicate values, you need to count the duplicate values. In this case, how can you calculate them quickly? For that, Excel provides the COUNTIFS function. With its help, we can get the count of specific values in the range. Today, we will guide you to learn the Formulas to count the values that appear in a List or Table in Excel. Get an official version of MS Excel from the following link:

Use Formula to Count Items in a ListPin
Use Formula to Count Items in a List

General Formula

Here we come up with a simple formula to find the total count of values that appear in a list in Excel.


Syntax Explanations

  • COUNTIFS – The Excel COUNTIFS Function will help to count the number of cells that match multiple criteria or conditions.
  • Range (A: A, B: B) – It represents the input ranges given in a worksheet.
  • Criteria (A1, B1)- It is the condition that helps to count the cells.
  • Comma symbol (,) – It is a separator that helps to separate a list of values.
  • Parenthesis () – The main purpose of this symbol is to group the elements.

How to Apply Formula to Count Items in a List?

In order to count the values in the range, we can use an Excel formula. This formula can make use of the COUNTIFS function for finding the total count of values that appears in the list repeatedly. For instance, we will need to find how many times a specific value appeared in the list.

The following image will show you a list of fruits and count the values in the range.

Input RangePin
Input Range

After that, you can use the below-mentioned formula in any cell where you want to get the output result.


Enter the formulaPin
Enter the formula

Once you have entered the formula, click on the Enter button to execute it and get the result. After getting the result for the first cell, you just need to drag down the cell to fill the remaining cells in the range.


If the above-given scenario is not enough to understand this formula and want to learn this with a simple example, kindly move to the following section.

Alternate Example

Here we come up with a simple example to know how to apply this Excel formula in the spreadsheet.

  • In the below example image, you can see the list of student names in the range. And we want to get the count of those students’ names from the list.
Students NamePin
Students Name
  • Then, enter the given formula in a cell where you want to get the result.


Type the formulaPin
Type the formula
  • Finally, you will need to click the Enter button to get the result, as shown in the below screenshot.


Here, you can learn the Formulas used for counting the values that appear in a List or Table in Excel with brief explanations. If you have any doubt regarding this article or have any other questions related to Excel, let me know in the comments section below. To learn more, check out AawExcel. Read more on Excel Formulas.

Video Tutorial

The following video will show you how to use an Excel formula to count values that appear in the range in Excel.

Read Ahead:


Leave a Reply

Your email address will not be published. Required fields are marked *

Share to...