Google Sheets Cheat Sheet

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.

COUNT Syntax

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

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

ABC
1DataFormulaOutput
21=COUNT(A2:A)3
3TRUE
41 January
5Text
600:30

The three values counted are:

  1. 1
  2. 1 January (a date)
  3. 00:30 (a duration)

The arguments to COUNT can be provided as values (numbers or text), cell references, or range references:

=COUNT(1,"Text",A1,B1:B2)

COUNT Errors

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.

ABC
1DataFormulaOutput
2FALSE=COUNT(TRUE,FALSE,A2:A)2
3TRUE
4FALSE
5TRUE
6FALSE

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:

=COUNT()

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:

  1. Select the required cell while the formula bar is empty
  2. Type your answer in the formula bar
  3. You can click on the spreadsheet to add cell/range references

Complete all questions to solidify your understanding of the COUNT function.

COUNT Function Exercises
Enter a formula for each question in the formula bar for the spreadsheet below.
1. Sales
In cell C2, enter a formula that counts how many sales were made using a single range reference. Remember to start your formula with '='.
2. All Numbers
In cell D2, enter a formula that counts how many numbers are present in columns A, B, and C using a single range reference. Make your formula flexible so it can count numbers that might be added in the future.
ABCD
1SalespersonAmount# Sales# Numbers
2Dwight500
3Jim425
4Stanley475
5Phyllis450
6AndyNone
7
Click Here When Complete

FREE RESOURCE

Google Sheets Cheat Sheet

Learn 12 tips and tactics that will make your sheets more beautiful and user-friendly from today.

Google Sheets Cheat Sheet

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.

Kieran Dixon started using spreadsheets in 2010. He leveled-up his skills working for banks and running his own business. Now he makes Google Sheets and Apps Script more approachable for anyone looking to streamline their business and life.