These three functions are important for understanding different types of data.

COUNT

Counts cells containing numbers.

=COUNT(B2:B11)

Example:

Cell

Value

B2

500

B3

700

B4

Apple

B5

Blank

COUNT counts only the numeric cells.

COUNTA

Counts cells that are not empty.

=COUNTA(A2:A11)

It can count:

  • Numbers
  • Text
  • Dates
  • Other non-empty entries

COUNTBLANK

Counts empty cells.

=COUNTBLANK(A2:A11)

Quick Comparison

Function

Counts

COUNT

Numbers

COUNTA

Non-empty cells

COUNTBLANK

Empty cells

Practice

Create a student registration sheet containing:

  • Student Name
  • Age
  • Phone
  • Marks

Leave some cells blank and calculate COUNT, COUNTA and COUNTBLANK.

PreviousNext