Better Sheets

How to Use COUNT() in Google Sheets

Description

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

How To Actually Use COUNT() in Sheets

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

Try COUNT yourself

Use the COUNT formula to count the number of numeric values in the range A1:A10. The correct answer should return the total count of numbers.

Your formula

Hints (2)

Locale Separator ,

Official Docs

3 Better Sheets Tutorials

Create a Sheet of Sheets for Project Management and/or Data Management

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!

COUNT() INDIRECT() REPT() SPLIT() TRANSPOSE()

Anders Asks: Find first and last of filter by date

Useful for calculation or filters by dates.

Beginner

COUNT() IF() INDEX()

How to Count Numbers in a Row

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.

Beginner

AND() COUNT() COUNTA() COUNTIF() FILTER() +1 more

Transcript-matched member videos for COUNT(). Click through to watch.

Browse more tutorials

Hardest Formula: SumIF | Addition Based on Dates / Values

Demystifying the SumIF Formula. Add up your values based on a condition, even if that condition is a date.

SUMIF() UNIQUE()

Write Apps Script to Create a New Google Sheets Formula

Create a brand new custom formula in Apps Script. We'll do this for our Add-on we'll be publishing to the Google Workspace Marketplace.

Calculate ROAS in Google Sheets

Calculate Return on Ad Spend with a formula combination. Bonus: create a more elegant solution in Apps Script using JsDoc syntax to create an autocomplete native function. We use the formula combination of Concatenate / Round to create the ratio, but in Apps Script we do it a whole lot better.

Intermediate

CONCATENATE() ROUND()

How to Iterate Counting Blank Cells in Google Sheets

Count different types of blank cells. Cells with nothing in them.

Intermediate

ARRAYFORMULA() IF() ISBLANK() MAX()

Unlock these tutorials

Learn more about the COUNT() formula:

Generate a COUNT() formula for your needs

Describe your task in plain English and get a paste-ready formula that uses COUNT(). 2 free AI generations, no signup. Members get unlimited use.

Generate a COUNT() formula