Counting Numbers With COUNT
Count how many cells in a range contain numbers.
Why Counting Matters
Spreadsheets are full of numbers, but sometimes you just want to know how many there are. How many sales were recorded? How many test scores were entered?
The COUNT function answers exactly that question. It looks at a range of cells and tells you how many of them contain numbers.
Throughout this lesson you'll learn how COUNT works, what it ignores, and how to use it on real data. Let's start counting.
Meet the COUNT Function
The COUNT function takes one or more ranges and returns the number of cells that hold a numeric value.
Its basic shape is simple:
- =COUNT(range)
For example, if cells A1 through A10 contain numbers, this formula returns how many of them actually have a number in them.
=COUNT(A1:A10)All lessons in this course
- Counting Numbers With COUNT
- Counting Anything With COUNTA
- Finding Empty Cells With COUNTBLANK
- Spotting MAX and MIN Values