How to count cells with Excel formula

Posted On June 25, 2020

This post shows how to count cells with Excel formulas.

Excel provides 4 different functions to count cells: count(), counta(), countblank(), countif()

Let’s look at each in a bit more detail

=count(A1:A10)

Counts cells in the range which hold a value. Empty cells and cells containing formulas are not counted.

=counta(A1:A10)

Counts non-empty cells in the range. Cells containing formulas are counted.

=countblank(A1,A10)

Counts empty cells in the range.

=countif(A1:A10,”<10″)

Counts cells in the range which satisfy a condition. In this example, only cells with value less than 10 are counted.