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

What is the Count?

Using the Count function is the same as calculating the Average.


Try it: Count the values

Select Cell D6


Find COUNT in the list of functions and click it.

 

Excel wrote the following equation:

=COUNT(D2:D5)

 

The range is all of the numbers from Cell D2 through D5.There is a mistake here. This equation includes the Average in Cell D5.

 

The correct equation is:

=COUNT(D2:D4)

 

Please edit the equation in Cell D6 so that the range is right.

 

Home ->Edit ->Count