COUNTA Function in Excel: Syntax, Examples and Free Practice
COUNTA is an Excel Statistical function. Counts how many cells in a range are not empty.
COUNTA syntax
=COUNTA(value1, [value2], ...)
Arguments
value1: The first valuevalue2: An additional value (optional)
When to use COUNTA
COUNTA is used in data analysis work to summarize or test patterns across a data set.
Practice COUNTA online, free
Open the live Excel-style spreadsheet and try COUNTA yourself. No Excel install or sign-up needed to start.
Practice COUNTA now →COUNTA practice questions
- Customer names are in A2:A9 (some rows are empty). How many names are listed? Put it in…
- Using the same table, how many customers already have a status in B2:B9? Put it in D2.
- Quantities are in B2:B9. Some cells hold the text n/a and some are empty. How many cells…
- Using the customer table, find the share of rows that have a name (A2:A9), as a decimal…
- Attendance is marked P in B2:C7 (two days) and left empty when absent. How many P marks…
- The records start under a header in row 1. Count the customer records in column A…
- Using the attendance table, how many students attended on at least one day? Put it in E2.
- Using the customer table, how many rows have a name in column A but no status in column…
More Statistical functions
Frequently asked questions
What does the COUNTA function do in Excel?
Counts how many cells in a range are not empty.
What is the syntax of COUNTA in Excel?
The syntax is =COUNTA(value1, [value2], ...). value1: The first value; value2: An additional value (optional).
Where can I practice COUNTA online for free?
Open the free live spreadsheet on Cellgrids and try COUNTA yourself. No Excel install is needed and you can start without signing up.
All Excel formulas · Cheat sheet · Excel exercises · Statistical functions · Excel case studies · Excel tutorials · Excel shortcuts