The COUNTIF function in Google Sheets lets you analyze data in your spreadsheet and returns the number of times it appears in your document if it meets a set of specific criteria. Here’s how to use it.
Use COUNTIF to Match on One Type of Criteria
Fire up Google Sheets and open a spreadsheet with data you want to count.
Click on an empty cell and type
=COUNTIF(,) into the cell or the formula entry field, replacing
with the range of data to count and the pattern to test, respectively. It should look something like this:
Whether you want to count a single set of criteria in a range or multiple ones, the use of both COUNTIF and COUNTIFS will help you analyze the data inside your spreadsheet.