 |
The next function we will discuss is CountA. This will return the
number of entries (actually counts each cell that contains number data
OR text data) in the selected range of cells.
- Blank entries are not Counted.
- Text entries ARE Counted.
Let's use the table here for the discussion that follows.
We will look at several different specific examples that show how the CountA
functions can be used! |
|
A |
| 1 |
10 |
| 2 |
20 |
| 3 |
30 |
| 4 |
test |
| 5 |
|
|
| Example of CountA | Cells to
look at |
Answer |
| =CountA (A1:A3) | A1, A2, A3 |
3 |
| =CountA (A1:A3, 100) | A1, A2, A3 and
100 |
4 |
| =CountA (A1, A3) | A1, A3 |
2 |
| =CountA (A1, A4) | A1, A4 |
2 |
| =CountA (A1, A5) | A1, A5 |
1 |
1117971
info@exceltalk.net
|
