# COUNTBLANK

## Rational

Count only blank cells

## Description

The Excel COUNTBLANK function returns the count of blank cells within the reference arguments ignoring number and text cells.
For example, if A1:A10 contains three empty cells and remaining are filled with any value, to count blanks in the range A1:A10; =COUNTBLANK(A1:A10) will return 3 (ignoring any value in reference).

## Syntax

=COUNTBLANK(range)

## Parameters

range – Reference to count the blank cells.

## Return Value

An Integer indicating counts of blank cells.

## Key Notes

The COUNTBLANK function counts only blank cells in given range (value)
A cell with any value including zero or space is not counted.

### COUNTA

The COUNTA function count of numbers and text within the reference list of arguments ignoring blank cells, =COUNTA(A1:A10) will return 7 (disregard blank).

### AVERAGE

The AVERAGE function returns an average of numbers positioned in one or multiple ranges, =AVERAGE(5,15,30) add numbers and divide by 3, and returns 16.67.

### SUM

The SUM function returns a number after adding multiple numeric arguments together =SUM(5,10,15) the Excel add numbers together and returns 30.

### COUNTIF

The COUNTIF function returns a count of number based on given criteria like =COUNTIF(A1:A5,”>5″) that count numbers in the list >5 and returns 3.

### COUNT

The COUNT function count of numbers within the reference list of arguments ignoring text & blank cells, =COUNT(A1:A10) will return 5 (only numeric).