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 is used to count the number of cells in a cell range that meet a given condition. This function can be used to count cells which contain different types of values, such as numbers, dates, empty cells, non-empty cells or cells containing some special characters.

The COUNTIF function is a build-in function in Google Sheets and it is categorized as a Statistical Function.

You can use a logical operator in the COUNTIF function, such as: >,>=,<,<=<>,=, and the function also supports wildcards characters (*, ?) .

Google Sheets COUNTIF Function Syntax

The syntax of the Google Sheets COUNTIF function is explained as follows:

= COUNTIF (range, criteria)

Where the arguments of the COUNTIF function are as follows:

  • Range – This is a mandatory option, you want to use to apply the given conditions to count the number of matching cells in the specified cell range.
  • Criteria – This is a mandatory option, it used to define which cells will be counted

Google Sheets COUNTIF Function Examples

The below examples will show you how to use google sheets COUNTIF function to count the number of cells that match a given criteria in a cell range.

Example 1: If you want to count the number of cells that contain the “excel” text value in cell range B1:B4, then you can use the following COUNTIF formula:


google sheets COUNTIF function1

You can see that the above COUNTIF formula returns a result of 2, which shows that B1: B4 range contains two “excel” text value of the cell.

See Also: