|
Excel: A Question of Balance
The Count
Function counts numbers. The CountA
Function counts the number of cells, or variables, that are in a range.
CountA can count any type of information such as names (text), values,
even cells with error messages in them. Neither Count
function adds up empty (Null) cells. Try It: Use
the CountA Function Select Cell
D8. Go to
Formulas -> More Functions. Go to
Statistical. Click on
COUNTA.
|
||||
|
| ||||
Microsoft Excel 2007 Exam 77-602 Topic: 3. Creating and Modifying Formulas
3.2. Summarize data using a formula 3.2.1. Use SUM, COUNT, COUNTA, AVERAGE, MIN, and MAX