How to use "countif" in Google Sheets | Scribe

How to use "countif" in Google Sheets

4 steps | 9 seconds | Created by Tiffany from Scribe
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)
There is your result!

Tiffany made this Scribe in 9 seconds.

Favorite this Scribe?

Add to your favorites for easy access and receive notifications for any changes.