How to use CountIf in Google Sheets ?
|
Google
|
Aug 28, 2024
|
Google
4 Steps
How to use CountIf in Google Sheets ?
|
Google
|
Google
4 Steps
1
Navigate to https://docs.google.com
2
Select the "Cell" where you want your output to live
Let's assume you want to count how many people named "Erica" are in this dataset.
In the cell
3
Enter "=countif(B2:B7,"Erica")" and hit "Enter"
The countif syntax is as follows:
=COUNTIF(RANGE,CRITERIA)
4
There is your result!
By following these steps you can use countIf in google sheets
