What Is The Count?

The Count Numbers function uses the same steps as figuring the Average.


1. Try it: Count the values

Select Cell D7

Go to Formulas-> Function Library.

Go to AutoSum.

Click on Count Numbers.

 

Excel wrote the following equation:

=COUNT(D2:D6)

This is the wrong range.

 

Use your cursor to highlight (select) Cells D2:D4.

 

2. What Do You See Now?

The correct equation is:

=COUNT(D2:D4)

 

What Else Do You See? The Count is still formatted as Currency.

OK, Do This: Format the Number
Select Cell D7.
Go to Home->Number->General.

 

graphic1
grpahic2
Formulas->Function Library->AutoSum ->Count Numbers
 

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