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.