Exam 77-882: Microsoft Excel 2010
Core
5. Applying Formulas and Functions
5.1. Create formulas: Use SUM, COUNT, COUNTA, AVERAGE,
MIN, and MAX: COUNTA 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
or CountA add up the empty (Null) cells. 1. Try It: Use
the CountA Function Select Cell
D10. Go to
Formulas ->
Function Library. Go to More Functions->
Statistical. Click on
COUNTA. Keep going...
|
|
| |
