Formulas > =COUNT()

How To Use COUNT() Function in Google Sheets


Returns a count of the number of numeric values in a dataset.

What are the common questions about the COUNT formula?
How does the COUNT formula work in Google Sheets?
What does the COUNT formula count in a range or array?
Can the COUNT formula count both numbers and text?
Does the COUNT formula count empty cells?
Can the COUNT formula count cells based on specific criteria or conditions?
Are there any limitations or restrictions when using the COUNT formula?

How can the COUNT formula be used appropriately?
The COUNT formula in Google Sheets is used to count the number of cells in a range or array that contain numerical values. It can be used appropriately in various scenarios, such as:
Counting the number of sales transactions.
Counting the number of students who scored above a certain threshold.
Determining the number of completed tasks or assignments.
Counting the occurrences of specific numeric values within a dataset.

How can the COUNT formula be commonly mistyped?
The COUNT formula can be mistyped in different ways, including:
Misspelling the formula as "COUNTS" or "COUNTT."
Incorrectly capitalizing or lowercase letters, such as "Count" or "count."
Using incorrect or missing parentheses, e.g., "COUNT(A1:A10" or "COUNT(A1, A2, A3)".
Providing non-numeric arguments or ranges that do not contain numerical values.

What are some common ways the COUNT formula is used inappropriately?
The COUNT formula may be used inappropriately in the following ways:
Attempting to count cells with specific criteria or conditions (COUNTIF or COUNTIFS should be used instead).
Using it to count both numbers and text, as it only counts cells with numerical values.
Expecting it to count empty cells or cells with formulas that return empty or null values (use COUNTA for counting non-empty cells).
Applying it to count cells based on formatting or appearance rather than the actual content.

What are some common pitfalls when using the COUNT formula?
When using the COUNT formula, it's important to be aware of potential pitfalls, such as:
Forgetting that the COUNT formula counts only numerical values and excludes text or other non-numeric entries.
Misinterpreting the results when the range or array contains cells with formulas that return zero or empty strings.
Not updating the formula when the range or array being counted is modified or expanded.
Assuming that the COUNT formula can count cells in multiple sheets or workbooks simultaneously (it can only count within a single sheet).

What are common mistakes when using the COUNT formula?
Common mistakes when using the COUNT formula include:
Using the wrong range or array reference, resulting in incorrect counts.
Failing to understand that the COUNT formula counts numerical values only, leading to unintended results.
Not adjusting the formula when new data is added or removed from the range or array.
Believing that the COUNT formula can count cells with specific criteria or conditions without using appropriate functions like COUNTIF or COUNTIFS.

What are common misconceptions people might have with the COUNT formula?
Common misconceptions about the COUNT formula include:
Assuming that it counts both numerical values and text, when it counts only cells with numerical values.
Believing that it can count cells based on specific criteria or conditions (for that, COUNTIF or COUNTIFS should be used).
Thinking that it automatically adjusts the count when new data is added or removed from the range or array (manual adjustment or dynamic ranges are necessary).

Google Sheet Formula Frustrations Solved
Find every formula you'll ever need in Google Sheets here at Better Sheets. Whether you're a beginner or an advanced user, I’ve got you covered with a comprehensive guide of 504 formulas.

Are you struggling to find a specific value in a column of data? Look no further than the powerful VLOOKUP formula. Or maybe you need to calculate the sum of values that meet specific criteria - try out SUMIF. And when it comes to frequency of values, COUNTIF has you covered.

Have you heard of the mysterious and powerful IF formula? It can turn your spreadsheets into gateways of productivity. And don't forget about the oft-partner ISBLANK(). 

Find step-by-step tutorials for any formula here on Better Sheets. Every formula page comes with links to written blog posts and Better Sheets tutorials featuring the exact formula.

Looking for a way to segment data based on specific criteria? The FILTER formula is perfect for you. 

If you need to replace VLOOKUP, give INDEX/MATCH a try.

At, I have everything you need to take your Google Sheets skills to the next level. 
From ARRAYFORMULA() to ZTEST(), Better Sheets has it all. 

How To Actually Use COUNT() in Sheets

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

3Better Sheets Tutorials

Useful for calculation or filters by dates.
Create an epic organization sheet of all your spreadsheets. Unlock the secret to compiling all your scattered information into one easy-to-use sheet. Learn how to merge data from multiple tabs with this one-sheet solution. Perfect for creating summaries and dashboards. Get started now and streamline your workflow!
Got this question in the Facebook Group: How to count the number of numbers in a row. I saw two possible solutions mentioned in the comments and wanted to go through why those are okay but there is a much more flexible and better solution.

Learn more about the COUNT() formula:

Generate a COUNT() formula for your needs with AI

Google Sheets Formula Generator

Whatever you need to do in sheets, you can generate a formula. Use the Better Sheets Formula generator to create a formula for any need. Completely free for members.


Looking for more help inside sheets get the free Add-on: Asa. Ask Sheets Anything. Go ahead, ask it any problem you migth have. Bring your own APIKEY and generate formulas inside of Google Sheets.