How to use "countif" in Google Sheets | Scribe

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
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.

Message sent!
This Scribe is in tip-top shape!Leave feedback if there are any issues with this Scribe