Documentation/How Tos/Calc: COUNTBLANK function

CALC FUNCTIONS

Mathematical Functions

< Previous Section

Next Section >

FUNCTIONS

Trigonometric

• Cos
• Sin
• Tan
• Cot
• Acos
• Acot
• Asin
• Atan
• Atan2
• Degrees
• Radians
• Pi

Hyperbolic

• Cosh
• Sinh
• Tanh
• Coth
• Acosh
• Acoth
• Asinh
• Atanh

Rounding and remainders

• Trunc
• Round
• Rounddown
• Roundup
• Ceiling
• Floor
• Even
• Odd
• Mround
• Int
• Quotient
• Mod

Logarithm/Powers

• Exp
• Power
• Log
• Ln
• Log10

Bessel functions

• Besseli
• Besselj
• Besselk
• Bessely

Miscellaneous

• Abs
• Combin
• Combina
• Convert
• Convert Add
• Countblank
• Countif
• Delta
• Erf
• Erfc
• Fact
• Factdouble
• Gcd
• Gcd Add
• Gestep
• Iseven
• Isodd
• Lcm
• Lcm Add
• Multinomial
• Product
• Rand
• Randbetween
• Seriessum
• Sign
• Sqrt
• Sqrtpi
• Subtotal
• Sum
• Sumif
• Sumsq

< Previous Page

Next Page >

COUNTBLANK

Returns the number of empty cells.

Syntax:

COUNTBLANK(range)

Returns the number of empty cells in the cell range range.

A cell that contains blank text such as spaces, or even text with zero length such as returned by ="", is not considered empty, even though it may appear empty.

Example:

COUNTBLANK(A1:B2)

returns 4 if cells A1, A2, B1 and B2 are all empty.

Advanced topic:

SUMPRODUCT(TRIM(CLEAN(A1:B2))="")

returns the count of cells that appear blank - that is, that are really empty or that contain blank text or zero length text.

SUMPRODUCT(ISTEXT(A1:B2);TRIM(CLEAN(A1:B2))="")

returns the count of cells containing blank text and zero length text.

---

See Also

• COUNT
• COUNTA
• COUNTIF
• ISBLANK

• SUMPRODUCT
• TRIM
• CLEAN
• ISTEXT

• Conditional Counting and Summation

• Mathematical functions

• Functions listed alphabetically
• Functions listed by category