Excel COUNTBLANK() Function

Excel COUNTBLANK() Function

The COUNTBLANK() function in excel counts the number of blank cells within a range.

Syntax

COUNTBLANK ([value1], [value [2], ...)

Parameter

value1(required)- This parameter represents the first cell in the range.

value2, …(optional)- It represents the second, third, and so on cells in the range.

Category

Statistical

Returns

This function returns the count of the number of blank cells within a range.

Example 1

Objective: To count the number of empty cells in the above table

List of Numbers	Result	Formula
13	11	50	0	=COUNTBLANK(A18:C18)
191	A	1	0	=COUNTBLANK(A19:C19)
82		20	1	=COUNTBLANK(A20:C20)
-82.5		B	1	=COUNTBLANK(A21:C21)

Example 2

Rows/Columns	B	C	D	E	F
90	Emp_ID	Employee Name	City/State	Department	Salary
91	E001	Beena Singh	New York	Marketing
92	E002	Ritu Sisodia		Sales Executive
93	E003	Gajni Seth	Texas		$115,550
94	E004	Ram Nath Kovind	Texas	Customer Support	$99,500
95	E005	Govind	Texas	Customer Support	$35,000

Objective: To count the non-empty cells in the data

Result	Formula
3	=COUNTBLANK(B90:F95)

Related Topics

Shortcut Keys in Excel

Shortcut Keys in Excel Shortcut keys in Excel are used to simplify the work and save time by pressing a few keys. These keys are used for navigating and working with Excel spreadsheets quickly and easily. Basic Selection:...

9 minutes read.

How to Make Use of the F-Test in Excel

Intro to F-Test in Microsoft Excel F-Test is primarily considered to be the essential tool of statistical in Microsoft Excel that, in turn, is used to do the hypothesis test with...

7 minutes read.

Excel OFFSET () Function

Excel OFFSET () Function The OFFSET() function in excel returns range of cells that is a specified number of rows and columns from an initial specified range. Syntax OFFSET (reference, rows, cols, [height], [width]) Parameter reference(required)-...

2 minutes read.

Excel RIGHT() Function

The RIGHT() function in excel returns the rightmost characters from a text value. This function is used for data manipulation. Syntax RIGHT(Text, [num_chars]) Parameter Text (required)- This parameter represents the string from which you want to find...

1 minute read.

Thermometer Chart in the Microsoft Excel

It was known that the thermometer chart is basically based on a single data point and that in turn could be used to show the achievement percentage. It primarily depends...

7 minutes read.

Data Analysis in Excel

Data Analysis in Excel Data analysis is a powerful tool that helps the users to make better decisions by comparing different information. Microsoft Excel extends its credibility to enforce the data analysis tool...

6 minutes read.

Notes in Excel

Notes in Excel Notes are used to include additional information to the cell and explain formulas calculation, any modification made to the cell, providing necessary information on data that is entered or to provide any...

3 minutes read.

Cells and Ranges in Excel

Cells and Ranges Each cell is identified by its cell address, which is a combination of the column and row on which that cell is situated. A group of cells together are called ‘Range’. When...

5 minutes read.

AutoFill in Excel

AutoFill in Excel Excel is known for its credibility to operate repeated and similar tasks automatically. For this purpose, it facilitates an inbuilt feature known as Autofill that recognizes the series of...

3 minutes read.

Excel ROUND() Function

Excel ROUND() Function The ROUND() function in excel rounds the numbers to specified digits. Syntax ROUND(Number,num_digits) Parameter Number(required)- This parameter represents the number which you want to round up. num_digits(required)- This parameter represents the number of decimal places to which...

1 minute read.

Array Formula in Excel

How to use Array Formula in Excel? By default, Excel consists of various formulas for calculating the data. Among various formulas, the Array formula is a powerful one that is used...

8 minutes read.

What if Analysis Data Table in Excel

What is What-If Analysis? Suppose you have a cell A15 which is formula driven i.e. has a formula and the formula is based on values in different cells (A1, A2, A3, A4), what-if...

4 minutes read.

Application Interface and Key Components

The essential key components of Excel are as follows: Ribbon TabQuick Access ToolbarFormula BarActive CellColumnsRows Name BoxSheet TabsZoom ControlStatus Bar Ribbon Tab: The ribbon includes tabs labeled Home, Insert, Page Layout, Formulas, Data, Review,...

3 minutes read.

How to apply Data Protection to the Worksheet?

What do we mean by Data Protection? Data Protection in excel involves in protecting your file/data from some other user and also prevents the following accidents – Accidentally deleting or changing the formulas in...

3 minutes read.

Excel MIN() Function

Excel MIN() Function The MIN() function in excel returns the smallest or minimum value from the provided numbers, named range or array. It ignores logical values and text. Syntax MIN(Number1,Number2, ...) Parameter Number1(required)- This parameter represents the...

1 minute read.

Excel COUNTIFS() Function

Excel COUNTIFS() Function The COUNTIFS() function in excel is used to count the numbers within a range that meet the supplied criteria. Syntax COUNTIFS (range1, criteria1, [range2], [criteria2], ...) Parameter Range1 (required)- This parameter represents...

1 minute read.

Formatting in Excel

Formatting in Excel Formatting in Excel is used to alter and change the appearance of your data in a standardized form. It also helps you to give a professional look to your reports, worksheets,...

7 minutes read.

Gauge Chart in Excel

A Gauge Chart in Microsoft Excel is considered the meter type chart of a group dial chart, which is eventually similar to the speedometer that has the pointer towards the...

7 minutes read.

Calculating Age in Excel

Microsoft Excel provides separate functions for various mathematical operations. Nowadays, Microsoft Excel is widely used by large and various organizations. Using formulas one can calculate the statistical functions quickly and...

2 minutes read.

How to Delete Row in Microsoft Excel?

Individuals can quickly delete the respective row from the particular Microsoft Excel whenever they want, according to their needs and requirements. In this tutorial, we will discuss the following things in...

7 minutes read.