How to use the COUNTIFS Formula in Excel

The COUNTIFS formula is a formula used to apply multiple criteria to a range of cells to count the number of times it meets all of those criteria. The formula applies criteria to cells across multiple ranges and counts the number of times all criteria are met.

COUNTIFS Formula Explained:

=COUNTIFS (criteria_range, criteria1, [criteria_range2, criteria2], …)

  • Criteria_range1 (required) — The first range in which to evaluate the criteria set in criteria.
  • Criteria1 (required) — The criteria in the form of a number, expression, cell reference, or text that define which cells are to be counted within the criteria1 range.
  • Criteria_range2, criteria2, … (optional) — Additional ranges and their related criteria. You can enter up to 127 range/criteria pairs.
  1. Criteria1 formula was used for determining a specific branch location.
  2. Criteria_range2 formula was used for determining the data range of what type of product description should be counted.
  3. Criteria2 formula was used for filtering only the specified product description required.