Statistical FunctionsBeginner

COUNT Function (Statistical)

The denominator, before you quote any statistic at all.

Task:

You are about to report an average satisfaction score. First you need to know how many people actually gave you a number. Put that count in B7.

Hints

+5 XPno-hints bonus

Solve it on your own to keep the bonus. Each hint gets one step closer to the formula.

Variations of COUNT, COUNTA

0/3

The same formula in the other shapes it takes at work.

  1. COUNT Function (Statistical)

    The denominator, before you quote any statistic at all.

    CoreBeginner
  2. A response rate from COUNT and COUNTA

    Numeric answers divided by people asked.

    Intermediate
  3. COUNT over a block

    One range can cover a whole grid of readings.

    Beginner

The data in this exercise

This is the grid you start with. Cell references in the task — B6, C2 — point at the row numbers and column letters below.

7 rows × 2 columns1 cell you fill in
AB
1RespondentScore out of 10
2R-018
3R-02No answer
4R-036
5R-049
6R-05
7Usable scores
What this exercise teachesMay contain the answer

Five people were surveyed and three of them gave a score. Reporting "average satisfaction 7.7" without mentioning that it rests on three responses is the kind of number that survives exactly until somebody asks. COUNT finds the denominator, and it ignores text on purpose so that a written-in "No answer" cannot quietly inflate it.