Share this article:

What it does: The COUNTIFS() Function allows you to count the number of cells that match multiple criteria.

Plain English: This formula is the logical extension of the COUNTIF() formula. Instead of counting based on one criteria, i.e. “How many cells are TRUE?”, you can count cells based on multiple criteria, i.e. “TRUE, Greater than 100, within 2017”

Arguments: DATE(criteria_range 1, criteria, [criteria_range 2], [criteria])

  • Criteria_range 1 – What is the range where you want to search for the first criteria?
  • Criteria 1 – What is the criteria within the first range?
  • Criteria_range 2 – optional – What is the range where you want to search for the second criteria?
  • Criteria 2 – optional – What is the criteria within the second range?

Blog Posts using COUNTIFS()