COUNTA practice

COUNTA counts the cells that are not empty, whatever they contain. Below are the 3 Google Sheets exercises on Sheetsdrill that use it, each checked instantly in your browser.

Syntax

COUNTA(value1, [value2], ...)

What people get wrong

A cell with a formula that returns an empty string counts as not empty.

Google Sheets exercises that use COUNTA

• Count the survey responsesLevel 1Pro
• Two conditions in FILTERLevel 4Pro
• Distinct customersLevel 4Pro

Often used together with: COUNT, FILTER, UNIQUE