Save this Scribe
How to use "countif" in Google Sheets
Created by Tiffany from Scribe
This Scribe shows you how to use the
function in Google Sheets to count instances in a dataset based on 1 single criteria. For multiple criteria, use the
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
syntax is as follows: =COUNTIF(RANGE,CRITERIA)
There is your result!
Tiffany made this Scribe in 9 seconds.
Show Me How
Favorite this Scribe?
Add to your favorites for easy access and receive notifications for any changes.