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!
Documents you might like
0 Selected
This Scribe is in tip-top shape!Leave feedback if there are any issues with this Scribe
Have something to say?Create an account to leave messages for the author to see!
Press space bar to start a drag.
When dragging you can use the arrow keys to move the item around and escape to cancel.
Some screen readers may require you to be in focus mode or to use your pass through key