4 steps | 9 seconds | Created by Tiffany from Scribe
google.com
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
1
Select the cell where you want your output to live
Zoom Saved
2
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)