Count blank cells in Excel and Google Sheets

=COUNTBLANK(A2:A6)

=COUNTIF(A2:A6,"")

A2:A6 = Range

Check below for a detailed explanation with pictures and how to use formulas in Excel and Google Sheets.

Count blank cells in Excel

How to count empty cells in Excel?
Count blank cell in Excel

COUNT BLANK CELL — EXCEL FORMULA AND EXAMPLE

=COUNTBLANK(A2:A6)

=COUNTIF(A2:A6,"")

  • 💡 You can also use multiple ranges "=COUNTBLANK(A2:A6, B2:B6)" in which the number of blanks is counted

Count blank cells in Google Sheets

How to count empty cells in Google Sheets?
Count blank cell in Google Sheets

COUNT BLANK CELL — GOOGLE SHEETS FORMULA AND EXAMPLE

=COUNTBLANK(A2:A6)

=COUNTIF(A2:A6,"")

  • 💡 You can also use multiple ranges "=COUNTBLANK(A2:A6, B2:B6)" in which the number of blanks is counted

Wild cards and regular expressions in Excel and Google Sheets

Wild cards and regular expressions
Other widely used Excel and Google Sheets functions explainedOthers FormulasDate and time functionsNumber based criteriaText-based criteriaExtract functions