How to count non-empty cells using COUNTIF

In this Excel Training video, we’ll show you how to use the COUNTIF function in Excel to tally the number of non-empty (not blank) cells within a specified range. Additionally, we’ll demonstrate how to count the empty cells in the same range and provide insights into counting cells based on specific keywords or patterns, allowing you to gain a comprehensive understanding of how to efficiently analyze and manage data using COUNTIF in Excel.

Resources

Count non-empty cells:

=COUNT(RANGE, "<>")

In the examples above and below, the “range” could be a range of cells, such as A1:A10

Count empty cells:

=COUNT(RANGE, "")

Count cells that contain a keyword:

=COUNT(RANGE, "*keyword*")

Count cells where the value is greater than 100:

=COUNT(RANGE, ">100")

Count cells that match a pattern:

=COUNT(RANGE, "*/??/*");

If a cell contained a date, such as 01/01/2023, it would be counted using the function above.