SheetFX
≡
<< Go back to all functions

COUNTIFS

The COUNTIFS function in Google Sheets is a powerful tool to return the count of a range depending on multiple criteria. It allows you to count the number of cells that meet multiple conditions. Whether you're analyzing survey responses, filtering data, or tracking inventory, the COUNTIFS function simplifies the task. Dive into our comprehensive guide to master its application.

Function Syntax and Parameters

Syntax: COUNTIFS(criteria_range1, criterion1, [criteria_range2, criterion2, ...])

Parameters:

  • criteria_range1: The first range to evaluate against the corresponding criterion.
  • criterion1: The condition or criteria to use for counting.
  • criteria_range2, ...: [Optional] Additional ranges and criteria to evaluate.

Step-by-Step Tutorial

  1. Using COUNTIFS with a single criteria:

    • Example: =COUNTIFS(A1:A5, "Apple")
    • Result: Returns the count of cells in range A1:A5 that contain the text "Apple".

  2. Using COUNTIFS with multiple criteria:

    • Example: =COUNTIFS(A1:A5, "Apple", B1:B5, ">5")
    • Result: Returns the count of cells in range A1:A5 that contain the text "Apple" and cells in range B1:B5 that are greater than 5.

Use Cases and Scenarios

  1. Survey Analysis: Count the number of respondents who selected multiple options.
  2. Inventory Management: Determine the quantity of items that meet specific criteria.
  3. Sales Funnel Tracking: Calculate the number of leads that satisfy multiple conditions.

Related Functions

  • COUNT: Count the number of cells in a range that contain numbers.
  • COUNTA: Count the number of non-empty cells in a range.
  • SUMIFS: Sum values based on multiple criteria.

Related Articles