In this post, you’ll learn about COUNTBLANK Function its syntax and the way of using COUNTBLANK Function in excel spreadsheet.
What is COUNTBLANK Function?
The COUNTBLANK Function in excel is a statistical Function .COUNTBLANK Function will count the number of empty cell in a given range of cells. Ignore cells that contain text, number, and errors.
In financial analysis, this function will be useful in highlighting counting the empty cells.
Syntax
=COUNTBLANK(range)
Arguments:
- = – built-in function.
- COUNTBLANK() – function name.
- range – specifies the range of cells.
Note:
- Ignores any cells that contain text, number, errors and even zeros.
- Arguments can be formulas that return empty text(“”) are considered as blank cells.
How to use COUNTBLANK Function in Excel?
COUNTBLANK Function is used to count only the empty cells.
Example:
Step 1:
Open the workbook in your Microsoft Excel.
Step 2:
Enter the data, in the workbook.
STEP 3:
In the new cell, give the formula or the syntax. Start with ‘ =’ for every functions, COUNTBLANK to initiate functions name, followed by open parenthesis.
The values are from A3 to A7.
STEP 4:
Press enter to get the results.
Return 2. There are 2 blank cells.