I. Intro
The COUNTBLANK function counts the number of blank cells in the specified cell range.
II. Explanation
- Formula: =COUNTBLANK(range)
- Parameters:
- Range: The area where the number of blank cells needs to be counted.
- Example:
- =COUNTBLANK(A2:C7)
III. Steps
Use the COUNTBLANK function
- Select a cell and click Formulas on the toolbar, then select Math > COUNTBLANK. You can also directly enter =COUNTBLANK in a cell.
- Enter the parameters in the cell. For example: COUNTBLANK(A2:D10).
- Press Enter to display the result, which is 3 in this example.
- Drag the + icon in the lower-right corner of the cell to apply the formula to more cells as necessary.
250px|700px|reset
Delete the COUNTBLANK function
Select the cell with the COUNTBLANK function and press Delete.
IV. Use case
Auditing: Quickly find missing data
Finding missing data, such as a budget that hasn't been set yet, is critical for auditing. Luckily, the COUNTBLANK function makes it easy to determine whether any data is missing by counting the number of blank cells.
- Formula used below: =COUNTBLANK(A1:G5)
- About the parameters: By using the COUNTBLANK function on the A1:G5 range, the result of 4 shows that 4 cells in the data set have missing values.
250px|700px|reset