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

Team Creator

Can add organization

Can change organization

Can delete organization

Can view organization

Can view scribe user

Can view super organization

Can view role

Can add user organization permission

Can view user organization permission

Scribe

enterprise

How to use "countif" in Google Sheets

Tiffany made this Scribe in 9 seconds.