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

Lookup and Reference Examples

  • Left Lookup in Excel
  • Find Closest Match in Excel Using INDEX, MATCH, ABS and MIN functions
  • How to use Excel MMULT Function
  • How to get address of named range in Excel
  • Complete List of Excel Lookup and Reference Functions, References and Examples

Data Analysis Examples

  • How to combine 2 or more chart types in a single chart in Excel
  • Get column name from index in Excel Table
  • Conditional Formatting New Rule with Formulas in Excel
  • Number and Text Filters Examples in Excel
  • Get column index in Excel Table

Data Validation Examples

  • Excel Data validation don’t exceed total
  • Excel Data validation no punctuation
  • Excel Data validation with conditional list
  • Excel Data validation whole percentage only
  • Excel Data validation must contain specific text

Count Blank/Nonblank Cells in Excel

by

This example shows you how to count the number of blank and nonblank cells in Excel.

1. The COUNTBLANK function counts the number of blank cells.

2. The COUNTA function counts the number of nonblank cells. COUNTA stands for count all.

Post navigation

Previous Post:

How to Count Number of Characters in a Cell or Range of Cells in Excel

Next Post:

Mark Workbook as Final 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
  • CONCAT function: Description, Usage, Syntax, Examples and Explanation
  • LEFT, LEFTB functions: Description, Usage, Syntax, Examples and Explanation
  • How to count total words in a cell in Excel
  • Find function vs Search function in Excel
  • How to add a line break with a formula while joining text strings in Excel
  • Get day from date in Excel
  • DATEDIF function: Description, Usage, Syntax, Examples and Explanation
  • Get last weekday in month in Excel
  • NETWORKDAYS function: Description, Usage, Syntax, Examples and Explanation
  • TIME function: Description, Usage, Syntax, Examples and Explanation
  • RATE function: Description, Usage, Syntax, Examples and Explanation
  • NOMINAL function: Description, Usage, Syntax, Examples and Explanation
  • ODDFPRICE function: Description, Usage, Syntax, Examples and Explanation
  • ACCRINT 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