This Scribe shows you how to use the [[countif]] function in Google Sheets to count instances in a dataset based on 1 single criteria. For multiple criteria, use the [[countifs]] function

Select the cell where you want your output to live

Let's assume you want to count how many people named "Joe" are in this dataset. 
In the cell, type "=countif(A2:A7,"Joe")" and hit [[enter]]

The [[countif]] syntax is as follows:
=COUNTIF(RANGE,CRITERIA)

google.com

How to use "countif" in Google Sheets

Scribe Co

Admin

Can add organization

Can change organization

Can delete organization

Can view organization

Can view scribe user

Has super admin permission

Can change super organization

Can view super organization

Can add role

Can change role

Can delete role

Can view role

Can add user organization permission

Can change user organization permission

Can delete user organization permission

Can view user organization permission

Scribe

enterprise

How to use "countif" in Google Sheets

Tiffany made this Scribe in 9 seconds.

Favorite this Scribe?