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. You can select Cell D7 and change the formatting to General.

 

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

Exam 77-882: Microsoft Excel 2010 Core

5. Applying Formulas and Functions

5.1. Create formulas: Use SUM, COUNT, COUNTA, AVERAGE, MIN, and MAX: COUNT