Скачать или смотреть [Google Sheets] How to use the COUNTBLANK function.

Have you ever needed to count the number of blank cells in a large dataset without having to manually go through each one?

Let’s take a look at how to do just that.

We have a fictitious data set of customers that contains their contact information and order history.

If we need to set up a count to keep track of the number of missing phone numbers we can use the COUNTBLANK function on the phone column in column I. If you want to count the number of phone numbers you have instead of counting the blanks, you can use the COUNTA function.

Check out the card on the top right hand corner of the screen for a full explanation on how to use the COUNTA function.

In cell B1 if we type equals countblank open brackets and then select the entire all of the phone number data in column I. Once you press enter you will see that we are missing 2 phone numbers.

If we add one of the missing phone numbers the missing number count in B1 will automatically be updated to 1.