Google Sheets COUNT Function

This post will guide you how to use Google Sheets COUNT function with syntax and examples in Google Spreadsheets.

Description

The Google Sheets COUNT function counts the number of cells that contain numbers, and counts numbers within the list of arguments. It returns a numeric value that indicate the number of cells that contain numbers in a range.

The COUNT function is a build-in function in Google Spreadsheets and it is categorized as a Statistical Function.

Syntax

The syntax of the COUNT function is as below:

= COUNT(value1, [value2],…)

Where the COUNT function arguments are:

  • value1 -This is a required argument.  The first item, cell reference, or range within which you want to count numbers.
  • Value2 – This is an optional argument. You can enter up to 255 value arguments.

Note:

  • Arguments that are numbers, dates, or a text representation of numbers (for example, a number enclosed in quotation marks, such as “1”) are counted.
  • If the argument is an array or reference, only numbers in that array are counted. Empty cells, logical values, text, or error values in the array or reference are not counted.
  • You can use the COUNTA function to count logical values, text, error values.
  • You can use the COUNTIF function to count only numbers that meet certain criteria.

Google Sheets COUNT Function Examples

The below examples will show you how to use Google Sheets COUNT Function to count the number of cells that contain numbers in a range.

#1 To count the number of cells in the range B1:B4, just using the following Google Sheets formula:

=COUNT(B1:B4)

google sheets COUNT function1

Related Functions

  • Google Sheets COUNTIF function
    The Google Sheets CHOOSE function returns a value from a list of values based on index. The syntax of the CHOOSE function is as below:=CHOOSE (index_num, value1,[value2],…) …
Related Posts

Rank Numbers without Repetitive Ranks in google sheets

This article will guide you how to rank numbers in a range with unique ranking in google sheets. How to use the Rank function in google sheets to get a unique ranking for ranges with duplicate values. Ranking without Repetitive ...

Rank Numeric Values with Duplicate in Google Sheets

Suppose you have an urgent task of ranking a list with duplicate values, what would be the first approach you would think of? Is there a quick and easy way to do this task in Google Sheets? This article will ...

Google Sheets COUNTIF Function

This article will introduce you how to use the COUNTIF function in google sheets, and will show you a good example to better understand the usage of the COUNTIF function. Google Sheets COUNTIF Function Description The google sheets COUNTIF function ...

Count Attendance and Absence with Google Sheets COUNTIF

In our campus life and work life, we usually record everyone's attendance. Today we will introduce you the application of Google Sheets COUNTIF function to count the attendance. Using a week as an example, we use the following example to ...

Google Sheets AVERAGE Function
google sheets AVERAGE function1

This post will guide you how to use Google Sheets AVERAGE function with syntax and examples in Google Spreadsheets. Description The Google Sheets AVERAGE function returns the average of the numbers that you provided. The AVERAGE function is a build-in function ...

sort dates in chronological order in google sheets
sort dates in chronological order in google sheets1

Assume you have a date list that has different date formats, as seen in the accompanying picture. In this instance, google sheets’s Sort function will fail to sort them appropriately. However, you may convert all various date formats to a ...

Google Sheets IF Function
google sheets IF function1

This post will guide you how to use Google Sheets IF function with syntax and examples in Google Spreadsheets. Description The Google Sheets IF function perform a logical test to return one value if the condition is TRUE and return ...

Check If a Cell is Blank or Empty in Google Sheets
check if a range of cells is blank or empty in google sheets1

The article demonstrates how to check if a range of cells is blank or empty by ISBLANK and other functions to recognize empty cells in Google Spreadsheets and take appropriate action based on their status. There are several circumstances in ...

Sidebar