Skip to content
xlsoffice. All Rights Reserved
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Lookup and Reference Examples

  • Create hyperlink with VLOOKUP in Excel
  • How to use Excel MMULT Function
  • How to get last row in text data in Excel
  • How to get first column number in range in Excel
  • How to get address of last cell in range in Excel

Data Analysis Examples

  • Example of COUNTIFS with variable table column in Excel
  • How to Create Thermometer Chart in Excel
  • Conditional Formatting Color Scales Examples in Excel
  • Remove Duplicates Example in Excel
  • How to perform a t-Test in Excel

Data Validation Examples

  • Excel Data validation whole percentage only
  • Excel Data validation don’t exceed total
  • Excel Data validation require unique number
  • Excel Data validation must contain specific text
  • Excel Data validation must not contain

Count cells that are blank in Excel

by

This tutorial shows how to Count cells that are blank in Excel using the example below;

Formula

=COUNTBLANK(range)

Explanation

To count the number of cells that are blank, you can use the COUNTBLANK function.

Worked Example:   Summary count with COUNTIF in Excel

In the example, the active cell contains this formula:

=COUNTBLANK(B4:B8)

How this formula works

COUNTIF counts the number of cells in the range that don’t contain any value and returns this number as the result. Cells that contain text, numbers, dates, errors, etc. are not counted.

Worked Example:   Count unique values in a range with COUNTIF in Excel

You can easily count cells that are not blank using COUNTA function with the same range like so:

=COUNTA(B4:B8)
Worked Example:   Break ties with helper column and COUNTIF in Excel

Post navigation

Previous Post:

Count cells over 100 characters in Excel

Next Post:

Count cells that are not blank in Excel

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Learn Basic Excel

Ribbon
Workbook
Worksheets
Format Cells
Find & Select
Sort & Filter
Templates
Print
Share
Protect
Keyboard Shortcuts

Categories

  • Charts
  • Data Analysis
  • Data Validation
  • Excel Functions
    • Cube Functions
    • Database Functions
    • Date and Time Functions
    • Engineering Functions
    • Financial Functions
    • Information Functions
    • Logical Functions
    • Lookup and Reference Functions
    • Math and Trig Functions
    • Statistical Functions
    • Text Functions
    • Web Functions
  • Excel VBA
  • Excel Video Tutorials
  • Formatting
  • Grouping
  • Others
  • Remove leading and trailing spaces from text in one or more cells in Excel
  • Remove file extension from filename in Excel
  • Count Number of Words in Excel
  • FIXED function: Description, Usage, Syntax, Examples and Explanation
  • How to create email address from name in Excel
  • Add workdays no weekends in Excel
  • Find Last Day of the Month in Excel
  • Basic Overtime Calculation Formula in Excel
  • Calculate number of hours between two times in Excel
  • How to calculate percent of year complete in Excel
  • ODDFYIELD function: Description, Usage, Syntax, Examples and Explanation
  • COUPNUM function: Description, Usage, Syntax, Examples and Explanation
  • PPMT function: Description, Usage, Syntax, Examples and Explanation
  • ODDLYIELD function: Description, Usage, Syntax, Examples and Explanation
  • RECEIVED function: Description, Usage, Syntax, Examples and Explanation
Acronyms, Abbreviations, Initialism & What They Stand For
© 2022 xlsoffice . All Right Reserved. | Teal Smiles