Join us at GITEX 2024! Discover our solutions at Hall 4, Booth H-30 Book your live demo today.
header icon
document-icon
How to use CountIf in Google Sheets ?
By Mitisha
|
Aug 28, 2024
|
document-icon Google
|
4 Steps
document-icon
How to use CountIf in Google Sheets ?
By Mitisha
|
document-icon Google
|
4 Steps

1
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
Merged Image
3
Enter "=countif(B2:B7,"Erica")" and hit "Enter"
The countif syntax is as follows: =COUNTIF(RANGE,CRITERIA)
Merged Image
4
There is your result!
By following these steps you can use countIf in google sheets
Merged Image