Excel: A Question of Balance Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 More

What Is The Count?

Using the Count function uses the same steps as figuring the Average.


Try it: Count the values

Select Cell D7

Go to Formulas-> AutoSum.

Click on Count.

 

Excel wrote the following equation:

=COUNT(D2:D6)

This is the wrong range.

 

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

 

What Do You See Now?

The correct equation is:

=COUNT(D2:D4)

 

Formulas->AutoSum ->Count Numbers

 

 

  Microsoft Excel 2007 Exam 77-602 Topic: 3. Creating and Modifying Formulas

  3.2. Summarize data using a formula  3.2.1.  Use SUM, COUNT, COUNTA, AVERAGE, MIN, and MAX