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.


Count non-empty cells:


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

Count empty cells:


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.

John Gleave

John Gleave has been a researcher, content writer, and senior editor at Business Tech Planet since 2022. John was formerly a data analyst and web designer with expertise in several programming languages, such as JavaScript, JQuery, PHP, CSS, SQL, and more! With a passion for writing and technology, he has now focused his skills on crafting tech guides for BTP. You can connect with John on LinkedIn.

Recent Posts