COUNT Function in Excel: Syntax, Examples and Free Practice
COUNT is an Excel Statistical function. Counts how many cells in a range contain numbers.
COUNT syntax
=COUNT(value1, [value2], ...)
Arguments
value1: The first valuevalue2: An additional value (optional)
When to use COUNT
COUNT is used in data analysis work to summarize or test patterns across a data set.
Practice COUNT online, free
Open the live Excel-style spreadsheet and try COUNT yourself. No Excel install or sign-up needed to start.
Practice COUNT now →COUNT practice questions
- Some cells in the Marks column hold text. Using COUNT, count how many cells hold actual…
- Using COUNT, find how many invoices have an amount entered and put it in B7.
- Two days have no units recorded. Using COUNT, find how many days have a number entered…
- Absent students are marked AB. Using COUNT, find how many students appeared and put it…
- Using one COUNT over both columns, find the total number of readings taken (morning and…
- A blank Delivery days cell means the order is still pending. Using COUNT and COUNTA,…
- A zero reading is still a reading. Using COUNT, find how many readings were recorded…
- New customers get the next serial number. Using COUNT, find the next serial number and…
- Some bill amounts were entered as text (n/a). Using SUM and COUNT, find the average…
- Days taken is blank for tasks that are not finished. Using COUNT and COUNTA, find the…
More Statistical functions
Frequently asked questions
What does the COUNT function do in Excel?
Counts how many cells in a range contain numbers.
What is the syntax of COUNT in Excel?
The syntax is =COUNT(value1, [value2], ...). value1: The first value; value2: An additional value (optional).
Where can I practice COUNT online for free?
Open the free live spreadsheet on Cellgrids and try COUNT 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