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.

Count Main Function

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:


How to Use COUNT

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:


Non Numerical A

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)

Non Numerical B

In this formula:

COUNT in Google Sheets

The COUNT Function works exactly the same in Google Sheets as in Excel:

Count Google Function

AI Formula Generator

Try for Free

Excel Practice Worksheet

practice excel worksheet

Practice Excel functions and formulas with our 100% free practice worksheets!

  • Automatically Graded Exercises
  • Learn Excel, Inside Excel!

Free Download

Return to List of Excel Functions