5 Ways To Use Countifs In Google Sheets

The versatility of Google Sheets! One of its most powerful functions is the COUNTIFS function, which allows you to count cells based on multiple criteria. In this article, we'll explore five ways to use COUNTIFS in Google Sheets, with practical examples and step-by-step instructions.

What is COUNTIFS in Google Sheets?

Before we dive into the examples, let's quickly define what COUNTIFS is. COUNTIFS is a Google Sheets function that counts the number of cells in a range that meet multiple criteria. It's similar to the COUNTIF function, but allows you to specify multiple conditions.

Example 1: Counting Sales by Region and Product

Suppose you have a dataset with sales data, including the region and product sold. You want to count the number of sales for each region and product combination.

Formula: =COUNTIFS(A:A, "North", B:B, "Product A")

• A:A is the range of cells containing the region data
• "North" is the criteria for the region
• B:B is the range of cells containing the product data
• "Product A" is the criteria for the product

Example 2: Counting Grades by Student and Score Range

Imagine you have a dataset with student grades, including the student name and score. You want to count the number of students who scored within a specific range (e.g., 80-90).

Formula: =COUNTIFS(A:A, "John", B:B, ">80", B:B, "<90")

• A:A is the range of cells containing the student name data
• "John" is the criteria for the student name
• B:B is the range of cells containing the score data
• ">80" and "<90" are the criteria for the score range

Example 3: Counting Inventory by Category and Quantity

Suppose you have a dataset with inventory data, including the category and quantity. You want to count the number of items in each category with a quantity greater than 10.

Formula: =COUNTIFS(A:A, "Electronics", B:B, ">10")

• A:A is the range of cells containing the category data
• "Electronics" is the criteria for the category
• B:B is the range of cells containing the quantity data
• ">10" is the criteria for the quantity

Example 4: Counting Customer Feedback by Rating and Date

Imagine you have a dataset with customer feedback, including the rating and date. You want to count the number of customers who gave a rating of 4 or 5 within the last 30 days.

Formula: =COUNTIFS(A:A, ">3", B:B, ">="&TODAY()-30)

• A:A is the range of cells containing the rating data
• ">3" is the criteria for the rating
• B:B is the range of cells containing the date data
• ">="&TODAY()-30 is the criteria for the date range (using the TODAY function)

Example 5: Counting Employee Data by Department and Job Title

Suppose you have a dataset with employee data, including the department and job title. You want to count the number of employees in each department with a specific job title (e.g., "Manager").

Formula: =COUNTIFS(A:A, "Sales", B:B, "Manager")

• A:A is the range of cells containing the department data
• "Sales" is the criteria for the department
• B:B is the range of cells containing the job title data
• "Manager" is the criteria for the job title

Google Sheets COUNTIFS Function Gallery

Conclusion: Boost Your Productivity with COUNTIFS

The COUNTIFS function in Google Sheets is a powerful tool for data analysis. By using the examples above, you can unlock the full potential of COUNTIFS and boost your productivity. Whether you're working with sales data, inventory, customer feedback, or employee information, COUNTIFS can help you extract valuable insights and make informed decisions.

Take Action!

• Try out the examples above in your own Google Sheets documents.
• Experiment with different criteria and ranges to explore the full capabilities of COUNTIFS.
• Share your own COUNTIFS examples and tips in the comments below!

We hope this article has helped you master the COUNTIFS function in Google Sheets. Happy spreadsheeting!