Excel COUNT Function Examples – Excel & Google Sheets

Written by

Editorial Team

Reviewed by

Steve Rynearson

Last updated on November 9, 2023

This tutorial demonstrates how to use the COUNT Function in Excel.

What is the COUNT Function?

The Excel COUNT Function returns the number of cells within a given range that contain numerical values.

How to Use the COUNT Function

To use the Excel COUNT Function, type the following:

``=COUNT(B3:B11)``

In this case, COUNT returns 4, since there are four numerical values in the range B3:B11.

A few notes on this example:

• COUNT will count cells formatted as currency
• Blank cells are ignored
• Cells containing 0 are counted

Count Cells that Don’t Contain Numerical Data

If you need to count cells that DON’T contain numbers, you can use the formula below:

``=SUMPRODUCT(--NOT(ISNUMBER(B3:B11)))``

Don’t worry if this formula looks a bit intimidating! We’ll work through it step-by-step:

An Alternative Method

Another formula to count all cells in a range that don’t contain numerical data, is the following:

``=(ROWS(B3:B11)*COLUMNS(B3:B11)) - COUNT(B3:B11)``

In this formula: