If the range contains text strings, the criteria can be the text string within double quotes (e.g., “Apple”) or can be a cell reference that contains the text string.Note that when you use an operator with a number, you need to enclose it in double quotes. The function would check each number in the ‘range’ for this criterion. For example, to count the number of students who scored above 75 in a subject, you can use “>75” as the criterion. a text string, such as “Apple” or “Banana”.criterion – the condition that should be met for a cell to be counted.range – the range of cells from which you want to get the count.SYNTAX of COUNTIF Function in Google Sheets You May Also Like the Following Tutorials:.Example 6 – Count All Instances where a Keyword Appears.Example 5 – Counting All Non-empty Cells in a Range.Example 4 – Counting All Empty/Blank Cells in a Range.Example 3 – Counting All the Records Except US.
