How can I use COUNTA IF in Google Sheets?

By /

The COUNTA IF function in Google Sheets allows users to count the number of cells within a range that meet a specific criteria. This function can be utilized to quickly and efficiently calculate the total number of cells that contain data or fulfill a certain condition. By using this function, users can easily track and analyze data in their Google Sheets spreadsheet, making it a useful tool for data management and analysis.

Use COUNTA IF in Google Sheets

Often you may want to use the COUNTA function with an IF function in Google Sheets to count the number of cells that are not empty only if a cell in a corresponding column meets a certain requirement.

Fortunately you can just use the COUNTIFS function to accomplish this.

The following example shows exactly how to do so.

Example: Using COUNTA with IF in Google Sheets

Suppose we have the following dataset that shows the points scored by various basketball players:

Suppose we would like to count the number of players with “Guard” in the Position column but only if the corresponding cell in the Points column is not empty.

We can type the following formula into cell D2 to calculate this number:

=COUNTIFS(A2:A16, "Guard", B2:B16, "<>"&"")

The following screenshot shows how to use this formula in practice:

Google Sheets COUNTA IF

The formula returns a value of 5.

This means that there are 5 players with a value of “Guard” in the Position column where the corresponding value in the Points column is not empty.

We can verify this is correct by manually identifying the five players that meet these criteria:

Each of the highlighted rows contains a player with a value of “Guard” in the Position column where the corresponding value in the Points column is not empty.

Note: You can find the complete documentation for the COUNTIFS function in Google Sheets .

Additional Resources

The following tutorials explain how to perform other common tasks in Google Sheets:

x

Related terms:

  1. How can I use COUNTA IF in Google Sheets?
  2. When would you use COUNT vs. COUNTA in Excel?
  3. Count Specific Characters in Google Sheets How to count specific characters in google sheets?
  4. Google Sheets: Average Across Multiple Sheets
  5. How to Create Pivot Table from Multiple Sheets in Google Sheets?
  6. How can I use Google Sheets’ IMPORTRANGE with multiple sheets?
  7. Google Sheets: How do I sum across multiple sheets?
  8. How can I use XLOOKUP from another sheet in Google Sheets?
  9. How do I use VLOOKUP in Google Sheets to return the last matching value?
  10. How do I calculate 2 standard deviations in Google Sheets?