I P Count Function N


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 CountCells to look atAnswer
=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


I P Count Function N

1007701

Choose:   INTEK home   I   training  I   by Jim Tracy   I