Master Excel COUNT Functions: COUNT, COUNTA, COUNTBLANK & More

In this article we have discussed how Excel provides a number of count functions that are intended to make evaluating records simpler than before. These features are crucial tools for anyone working with spreadsheet statistics because they help users quickly count numbers, blanks, non-blanks, or values that fit certain criteria.

The Main COUNT Functions in Excel

How do count functions work?

1. COUNT:
   • This function only counts cells that contain numbers; it will not even include blank cells to count.
   • For example, =COUNT(B1:B10) will only return the count of numeric cells if cells B1:B10 contain both text and numbers.
2. COUNTA
   • The goal is to count all cells that are not empty, irrespective of the type of data (text, numbers, logical values, errors, etc.).
   • For example, using the same range, =COUNTA(B1:B10) counts all cells other than those that are actually blank.
3. COUNTBLANK
   • Goal: Determines the proportion of blank cells in a range.
   • For example, =COUNTBLANK(B1:B10) will display the number of empty cells, which is helpful for promptly identifying data gaps.
4. COUNTIF
   • Goal: Determines how many cells satisfy a particular requirement.
   • To count the number of cells in B1:B10 that are greater than 50, use the formula =COUNTIF(B1:B10, “>50”). This is ideal for real-time data filtering.
5. COUNTIFS
   • The number of cells that satisfy multiple conditions across ranges is counted.
   • For instance, if C1:C10 contains numbers and D1:D10 contains categories, then =COUNTIFS(C1:C10, “>100”, D1:D10, “A”) will determine the number of rows that simultaneously satisfy both requirements.

Practical Example Table

Copy this sample table into Excel to easily practice each function:

Watch a Video