When it comes to counting non-blank cells in Google Sheets, you will find the Countif function to be very helpful. It can help you to count non-empty cells with ease.
Countif is a function that is used for counting cells within a specified range that meet a certain condition. For example, you can use the Countif formula to count the number of cells containing a number lesser than a number that you specified. You can also use this function for counting cells with a specific word.
Since many of you don’t how to use this function, we are here to help. In this post, we will tell you how to count cells if not blank using the Countif function. All you have to do is just follow the steps correctly and you should be good to go. That said; now let’s walk you through the steps.
Steps to Count Cells If Not Blank Using COUNTIF function:
- Open Google sheets that have the list with blanks that you want to count:
- To count all the cells that are not blank, you can use the following function:
=COUNTIF($A$1:$A$20,"?*")+COUNT($A$1:$A$20)
Note: This formula only counts from cell 1 to 20
Also, check out How to Turn On Google Sheets Notifications? to know more.
