How to Use Different Types of COUNT Functions in Excel (5 Ways)

Microsoft Excel offers a number of methods for counting various cell types, including blank or non-blank cells, cells with numbers, times, or text values, cells containing specific words or characters, and so on. In this article, we will discuss how to use different types of count functions for counting in Excel.


Download Practice Workbook

You may download the following Excel workbook for better understanding and practice it by yourself.


Get Introduced with the Applications of 5 Different Types of COUNT Functions in Excel

There is a total of five functions used for counting, predominantly in Excel. These are namely the COUNT Function, the COUNTA Function, the COUNTIF Function, the COUNTIFS Function, and the COUNTBLANK Function. Here, we will apply five different count functions and you will learn how to use different types of count functions for counting in Excel.

Handy Ways of How to Use Different Types of Count Functions For Counting in Excel


1. Using COUNT Function to Count Cell Numbers

The COUNT function is used to determine the number of cells that contain numbers or the number of numbers in a list. It is the simplest of the counting functions. Dates are also counted when using this function. The syntax for the COUNT function is:

Step 1:

  • Here, we want to determine only the number of jobs in the list using the COUNT function.
  • Firstly, select the E17 cell.
  • Then, write down the following by selecting the range from the E5 cell to the E15 cell formula here.
=COUNT(E5:E15)

 Using COUNT Function to Count Cell Numbers in Excel

Step 2:

  • Finally, you will see the result of the number of jobs for tradies here is 8.


2. Utilizing COUNTA Function to Count Cell Texts

The COUNTA function is used to count the number of cells with text within a particular range that is not empty. This function counts numbers, error values, logical formulas, and formulas that return an empty text string. The syntax for the COUNTA function is:

Step 1:

  • Here, we want to use the COUNTA function to count the number of cells with text in the list.
  • Firstly, choose the E17 cell.
  • Then, by choosing the range from the B5 cell to the B15 cell formula here, write down the following formula.
=COUNTA(B5:B15)
  • Press the keyboard shortcut CTRL+ENTER after that.

 Utilizing COUNTA Function to Count Cell Texts in Excel

Step 2:

  • Lastly, you will observe here the 11 tradies available.


3. Applying COUNTBLANK Function to Count Blank Cells

The COUNTBLANK function counts the number of blank cells in a specified range. The syntax for the COUNTBLANK function is:

Step 1:

  • Here, there is a mixed list of data that has different values and a few blank cells, in between, and we want to use the COUNTBLANK function in order to determine the number of blank cells in the range.
  • In order to count the number of cells that are blank in the cell range E5: E15, we input the following formula into Cell E17.
=COUNTBLANK(E5:E15)

Applying COUNTBLANK Function to Count Blank Cells in Excel

Step 2:

  • Upon pressing CTRL+ENTER, we get a value of 3 returned, so of the cells in the range, there were only three blank cells.


Similar Readings


4. Inserting COUNTIF Function to Count with a Single Criterion

The COUNTIF function brings conditional logic into the equation and counts the number of cells that meet specific criteria. The syntax for the COUNTIF function is:

Step 1:

  • Here, we want to evaluate how many tradies work in Texas state.
  • Pick the E17 cell first.
  • Write down the following formula by selecting the range from the C5 cell formula to the C15 cell formula and specifically choosing the Texas state as the criteria.
=COUNTIF(C5:C15, "Texas")
  • Then, utilize the keyboard shortcut CTRL+ENTER.

Inserting COUNTIF Function to Count Specific Names in Excel

Step 2:

  • Consequently, you will notice that 6 tradies work in Texas state.


5. Using COUNTIFS Function to Count with Multiple Conditions

The COUNTIFS function is similar to the COUNTIF function, except it’s used to count the number of cells in a range that meet multiple criteria. All the criteria have to be met for COUNTIFS to count that specific value. So, if one thinks of this using logical formula logic, all conditions set have to evaluate to true for a row to be counted.

 Using COUNTIFS Function to Count Most Specific Names in Excel

Step 1:

  • Here, we want to determine how many tradies work in Texas state and they are Steam Engineers using the COUNTIFS function.
  • Firstly, select the E17 cell to apply the formula.
  • Then put down the following formula here by choosing the ranges C5 to C15 and D5 to D15 with Texas and Steam Engineer as the criteria respectively.
=COUNTIFS(C5:C15,"Texas",D5:D15,"Steam Engineer")
  • After that, hit CTRL+ENTER from the keyboard shortcut.

 Using COUNTIFS Function to Count Most Specific Names in Excel

Step 2:

  • As a result, you will find here that the 3 tradies who work in Texas state are steam engineers.


Conclusion

In this article, we’ve covered 5 handy ways to use different types of count functions in Excel for counting cell numbers, text numbers, the number of blank cells, and specific names in Excel. We sincerely hope you enjoyed and learned a lot from this article. Additionally, if you want to read more articles on Excel, you may visit our website, ExcelDemy. If you have any questions, comments, or recommendations, kindly leave them in the comment section below.


Related Articles

Taryn Nefdt

Taryn Nefdt

Taryn is a Microsoft Certified Professional, who has used Office Applications such as Excel and Access extensively, in her interdisciplinary academic career and work experience. She has a background in biochemistry, Geographical Information Systems (GIS), and biofuels. She enjoys showcasing the functionality of Excel in various disciplines. She has over ten years of experience using Excel and Access to create advanced integrated solutions.

We will be happy to hear your thoughts

Leave a reply

5 Excel Hacks You Never Knew

Genius tips to help you unlock Excel's hidden features

FREE EMAIL BONUS

ExcelDemy
Logo