IZero Clonecd key PZero Clonecd key CountA Function NZero Clonecd key

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.

Lets 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 CountACells 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

IZero Clonecd key PZero Clonecd key CountA Function NZero Clonecd key

901636

Choose:   TRIO homeZero Clonecd key   I   tutorialsZero Clonecd key   I   by Brad JamesZero Clonecd key   I   bwjames@usd.eduZero Clonecd key