Excel COUNTA Function

COUNTA Function

The COUNTA function is a premade function in Excel, which counts all cells in a range that has values, both numbers and letters.

It is typed =COUNTA

How to use the =COUNTA function:

  1. Select a cell
  2. Type =COUNTA
  3. Double click the COUNTA command
  4. Select a range
  5. Hit enter

Let's see some examples!

Apply the =COUNTA function to range A2:A21, counting Pokemons by their names, which are letters only:

COUNTA function, step by step:

  1. Select A23
  2. Type =COUNTA
  3. Double click COUNTA in the menu
  4. Select range A2:A21
  5. Hit enter

The COUNTA function has successfully counted 20 cells with values in the range A2:A21.

Lets apply the COUNTA function to D2:D21. Counting a range with numbers only.

That is great! The COUNTA function counts cells in a range with values both numbers and letters.