Welcome! Lets start your excel journey..

Welcome! Register Now to Unlock Exclusive Excel Tutorials

Get Started
  • Exclusive Playlists
  • Downloadable Videos
  • No Ads!
  • Exclusive Templates

How to Count Blank or Non Blank Cells in Excel

Duration: 6:38
Submitted: 6 months ago
Views: 332

Comments (0)

Link to this video:

Description: This tutorial will show how to count blank or non-blank cells in Excel. In order to count blank or non-blank cells in Excel, you need only a few steps. In the meantime, this article will show how to use the count functions in Microsoft Excel to perform the task. Table Of Content: 00:00 Introduction 01:08 Count Blank Cells Using COUNTBLANK 02:30 Count Non-Blank cells using COUNTA 03:40 Custom Criteria Based Counting Blank or non-blank cells. 06:00 Conclusion In Microsoft Excel, the COUNTBLANK function is used to count the cells in a row that are blank. To count blank cells using COUNTBLANK function, follow these steps: 1. Select the range of cells that you want to count. 2. Select Function from the toolbar and choose COUNTBLANK from the list of functions available. 3. Enter a label for your result in a cell which would be above or below the range of data you want to analyze, and press enter or click on OK button. — The COUNTBLANK function counts the number of blank cells in a range of a worksheet. The syntax for the function is given below. — COUNTBLANK(array) Returns the number of cells in an array that are empty. One of the most common uses for this function is to find out how many rows in a table contain no data. This is important to know because when we want to delete a row in a table, we need to know which one we want to delete and then we can use DELETE ROWS or DELETE COLUMNS and then specify that we want it to delete all rows with values of “”. — Count Non-Blank cells using COUNTA The function COUNTA is a useful way to counts non-empty cells in a range. The syntax is as follows: =COUNT(cell reference,”parameter”) In this case, cell reference would be the range of cells you want to count. Parameter is the criteria for counting. In order to count only those that are not blank, use “NONBLANK” as the parameter. For example: =COUNT(A1:A10,NONBLANK) — In Excel, there are a number of functions that can count the number of cells that have data in them. However, there is no function to count cells with no data in them. For the purposes of a given analysis, cells with no data will be important to know. For example, if you need to determine how many records have been filled out completely vs those that are incomplete. In order to accurately count these cells with no data in them, it is required to create a Custom Criteria for this particular selection or range.