Make COUNTIF function count cells that are not blank
Instead of counting the non-empty cells in your data set manually, you can have Excel to do it for you. Wonder how?
By using the COUNTIF function.
It automatically counts the number of all cells containing data in a selected range. Not only does it save you lots of time, but it also increases overall productivity 😀
Let’s see how to use the COUNTIF not blank function to count non-empty cells.
Say, we have the following sample data.
The data set consists of feedback from some customers for a product. As evident, not all customers gave feedbacks.
We want to count the number of not blank cells using the Excel COUNTIF not blank formula.
To do that,
- Select cell C2.
- Add the COUNTIF formula as:
- Enter the range containing the non-empty values.
- Enter the criteria as follows:
- Press Enter.
Excel will return the result as:
Excel counted all the non-blank cells for us on the range in seconds 🎯
How easy is that? You will be able to master this instantly.