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.
PSST, HEY, YOU
(YEAH, YOU!)
Want in on insightful videos, the latest tech developments, and epic exclusive content? Get all this and more as a member of our mailing list.
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.