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.
| Let's 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!
|Example of Count||Cells to look
|=Count (A1:A3)||A1, A2, A3||3|
|=Count (A1:A3, 100)||A1, A2, A3 and
|=Count (A1, A3)||A1, A3||2|
|=Count (A1, A4)||A1, A4 ||1|
|=Count (A1, A5)||A1, A5||1|
copyright 2009 brad