This guide was created with Scribe in 9 seconds. Sign in and create your own!
How to use "countif" in Google Sheets
Created by Tiffany from Scribe | 4 steps
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
Zoom Saved
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)
There is your result!
Zoom Saved
Tiffany made this Scribe in 9 seconds.
Have something to say?Create an account to leave messages for the author to see!
Message sent!
Feedback
This Scribe is in tip-top shape!Leave feedback if there are any issues with this Scribe