Statistical Functions
Beginner

COUNTA across a row: sessions attended

Any mark in a cell counts, whatever it says.

Task:

Trainers ticked attendance however they liked — a tick, an x, the word Yes. In G2:G6 give the number of sessions each person attended.

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.

6 rows × 7 columns5 cells you fill in
ABCDEFG
1NameS1S2S3S4S5Attended
2Abel✓✓✓✓
3Beaxx
4CyYesYesYesYesYes
5Di✓
6Ed✓xYes
What this exercise teachesMay contain the answer

COUNTIF on "✓" would miss the x and the Yes. When any entry means the same thing, COUNTA is the right tool — it does not care what was typed, only that something was. The cost is that a stray space also counts, so it pays to keep blanks genuinely empty.