COUNT Google Sheets Function [With Quiz]
In Google Sheets the COUNT function counts (shockingly) how many numerical values are contained in the values, cells, or ranges provided as arguments.
Other data types (like text) are ignored.
- value1 = a value, cell reference, or range reference from which to counting numerical values.
- [value2, ...] = [optional] additional values, cell references, or range references to count.
Dates, times, and durations are counted by COUNT because, in Google Sheets, dates and times are just numbers made to look like dates and times.
COUNT Function Example
The three values counted are:
- 1 January (a date)
- 00:30 (a duration)
The arguments to COUNT can be provided as values (numbers or text), cell references, or range references:
There is an interesting anomaly in the COUNT function that is unlikely to cause you too many issues.
If you include boolean data as a value it is counted.
If you include boolean data in a cell or range reference it is not counted.
It's a bit of a strange feature.
Outside of this, the COUNT function is incredibly resilient. It will output effectively even when inputs include blank cells, errors, and text (each of these counts as 0 to the output total).
The only error I could cause with COUNT was not including any arguments:
Which results in an #N/A error:
Wrong number of arguments to COUNT. Expected at least 1 arguments, but got 0 arguments.
COUNT Function Quiz
Here's a quick summary of how to use the quiz spreadsheet:
- Select the required cell while the formula bar is empty
- Type your answer in the formula bar
- You can click on the spreadsheet to add cell/range references
Complete all questions to solidify your understanding of the COUNT function.
|1||Salesperson||Amount||# Sales||# Numbers|
Google Sheets Cheat Sheet
Learn 12 tips and tactics that will make your sheets more beautiful and user-friendly from today.
By entering your email address you agree to get email updates from me. I'll respect your privacy and you can unsubscribe at any time.
You might like:
How To Highlight Duplicates In Google Sheets
Do you need to find and highlight duplicates in Google Sheets using conditional formatting? The custom formulas you need are right here.
LOWER Google Sheets Function [With Quiz]
The LOWER function in Google Sheets makes all text characters in a cell, column, or row lowercase. Learn how to make this happen here.
How To Subtract In Google Sheets
Google Sheets is good at subtracting... you can be too. Learn how to subtract numbers, columns, dates, times, percentages, all of it!
UPPER Google Sheets Function [With Quiz]
The UPPER function in Google Sheets makes every character in a cell, column, or row uppercase. Learn how to capitalize every letter here.
How To Make A Calendar In Google Sheets
You can use a single formula to generate a calendar for a month and year of your choice. Get a sheet to copy and the formula right here.
How To Calculate Standard Deviation In Google Sheets
Need to find the standard deviation using Google Sheets? Here's how to make it happen with samples, populations, and handling text values.