COUNTBLANK function is a formula used to count the number of empty cells within a specified range. It helps you determine how many cells in a given range do not contain any data, text, numbers, or formulas.
Syntax
COUNTBLANK(range)
range: This is the range of cells you want to count the blank cells within. It can be a single cell reference, a range reference, or an array.