Exam 77-420 Microsoft Excel 2013 4. Apply Formulas and Functions 4.2 Summarize Data with Functions: Demonstrate How To Apply the COUNTA Function

Formulas->Function Library->More Functions ->Statistical-> COUNTA

The CountA Function 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 count 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...