FormuladrillCOUNTA practice
COUNTA counts the cells that are not empty, whatever they contain. Below are the 1 Excel exercise on Formuladrill 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.
Excel exercise that use COUNTA
- Count the answersLevel 1Pro
Practice COUNTA now
The free exercises work without an account. Pro unlocks every exercise, with worked solutions and progress saved to your account.
Start practicing free