Statistical FunctionsBeginner

COUNTA Function

How many replied, regardless of what they said.

Task:

You sent five invitations and need the response rate. Put the number of people who replied at all in B7 — what they actually answered does not matter yet.

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.

    CoreBeginner
  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.

7 rows × 2 columns1 cell you fill in
AB
1InviteeReply
2AdayYes
3Bhatt
4CostaNo
5DuarteMaybe
6Ekwueme
7Replies received
What this exercise teachesMay contain the answer

Every reply in this column is a word, so COUNT returns 0 where COUNTA returns 3. That is the entire distinction between them, and it is the one that bites: point COUNT at a column of text and you get a confident zero rather than an error, which is a far harder mistake to spot.