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:

=COUNTIF(A1:A4,"excel")

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:

Related Posts

Free Wedding Guest List Templates

This article will show you some free wedding guest list templates for google sheet and Microsoft Excel Spreadsheet and will also provide some explanations about the features or important functional features of these templates. When you are using these templates, ...

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 ...

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 COUNT Function
google sheets COUNT function1

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 ...

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

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