Count Function

---

The next function we will discuss is Count. This will return the number of entries (actually counts each cell that contains number data) in the selected range of cells.

• Blank entries are not counted.
• Text entries are NOT counted.

---

Lets use the table here for the discussion that follows.
We will look at several different specific examples that show how the Count functions can be used!

	A
1	10
2	20
3	30
4	test
5

---

Example of Count	Cells to look at	Answer
=Count (A1:A3)	A1, A2, A3	3
=Count (A1:A3, 100)	A1, A2, A3 and 100	4
=Count (A1, A3)	A1, A3	2
=Count (A1, A4)	A1, A4	1
=Count (A1, A5)	A1, A5	1

---

Count Function

509726