Microsoft Office Tutorials and References
In Depth Information
Column D has a mix of text and numeric entries. If you want to count how many
people took the test, use COUNTA. If you want to count how many people re-
ceived a numeric score, use COUNT.
Figure 11.6. Whether you use
Whether you use COUNT
COUNT oor COUNTA
COUNTA depends on whether your
depends on whether your
data is numeric.
data is numeric. COUNT
COUNT counts only dates and numeric entries.
counts only dates and numeric entries. COUNTA
counts anything that is nonblank.