COUNTIF is a conditional function, like SUMIF, that lets you find the number of times that your data will meet certain criteria. I will show you how to use this function, as well as show a few examples.
Follow this Step By Step process to use the COUNTIF Function
- Type =COUNTIF(. This will initiate the Count-If function.
- Insert the range you want to analyze. Because we are looking for Grades from B-A, your best bet would be to select the cells below the Grade % Column.
- Set the Criteria. Because you are looking for anyone with a grade between 80-100, you can state “>79” Also, make sure that you add quotation marks to your criteria.
Counting By KeyPhrase
You can also count cells by Keywords or Letters. Instead of setting up a conditional range, simply input the desired Keywords or letters. For this Count-If equation, I want to find out how many students are named “Zeke”.
And there you have it; that is how you use the Count-If function in Google Sheets.