COUNT and COUNTA

BeginnerFree

10 questions, about 15 minutes

Count numbers, filled cells and empty cells.

What we'll do

  • The difference between COUNT and COUNTA
  • Counting empty cells

What you'll use

  • COUNTA
  • COUNT
  • COUNTBLANK

How it works

In an example you watch and don't need to fill anything in. You answer a question yourself. If it goes wrong, you get a tip, then a hint and finally the solution.

2examplesYou watch
10questionsYou do it yourself
Full explanation