What does it do?

Counts the number of cells that are blank

Formula breakdown:


What it means:

=COUNTBLANK(range of cells to check)

Do you have a scenario where you want to count the number of cells that are blank in your Excel data?

If you are auditing your data and want to make sure that a blank cell is actually blank (and doesn’t contain an invisible character), then this formula is for you.

There is a simple way to count blank cells using Excel’s COUNTBLANK formula!

I explain how you can do this below:


STEP 1: We need to enter the COUNTBLANK function in a blank cell:


CountBlank Formula in Excel


STEP 2: The COUNTBLANK arguments:


What is the range of values that you want to check how many are blank?


CountBlank Formula in Excel


You now have your count of values that are blank! There are 3 blank values!

CountBlank Formula in Excel


CountBlank Formula in Excel



If you like this Excel tip, please share itEmail this to someone


Pin on Pinterest

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn

Share on Google+

Related Posts

Round Off Numbers with Excel’s ROUND Formula What does it do?Rounds a number to the nearest decimal based on your specified number of digitsFormula breakdown:=ROUND(number, num_digits)What it means:=ROUND(the number, number of decimal places to round off)Ever had the need to round off numbers? ...
RANDBETWEEN Function for Excel Dates What does it do?Generates random dates, in between a start date and an end dateFormula breakdown:=RANDBETWEEN(bottom, top)What it means:=RANDBETWEEN(starting date for random date generation, end date for random date generation) If you need to ...
Extract First Name From Full Name in Excel There were countless times when I had a list of full names, and all I needed was the First Name. It would be time-consuming to manually get the first names one by one. Thank goodness there are formulas to make my life easier!In Excel, it's very easy to do that with the LEFT a...
CountIfs Formula in Excel What does it do?Counts the number of cells that matches your specified conditionsFormula breakdown:=COUNTIFS(range1, criteria1, , , ...)What it means:=COUNTIFS(range of cells to check1, condition to check against1, , , ...)Do you have a scenario where ...