Statistical Functions
Intermediate

A completion rate with COUNTA

Filled-in cells over total rows.

Task:

Every new starter must record an emergency contact. In B11 give the share of starters who have one recorded, counting filled-in contacts against names on the list.

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. COUNTA Function

    How many replied, regardless of what they said.

    Core
    Beginner
  2. COUNTA across a row: sessions attended

    Any mark in a cell counts, whatever it says.

    Beginner
  3. A completion rate with COUNTA

    Filled-in cells over total rows.

    Intermediate

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.

11 rows × 2 columns1 cell you fill in
AB
1StarterEmergency contact
2FarahAli (brother)
3Gus
4HanneOla (partner)
5IvoMum
6Jun
7KayaDev (friend)
8LiorSara
9Mina
10
11Completion rate
What this exercise teachesMay contain the answer

The same function counts both the top and the bottom of the fraction; only the column changes. Counting names rather than typing 8 means a new starter added to the list lowers the rate until their contact is in — which is the point of tracking it.