COUNTIFS Function in Excel

Question

How to do COUNTIFS?

Answer

The COUNTIFS function, similar to Excel's COUNTIF function, counts up the number of times data in two or more ranges of cells meets multiple criterion.  
 
The syntax for the COUNTIFS function is: =COUNTIFS( Criteria_range-1, Criteria-1, Criteria_range-2, Criteria-2, ...)

  • Criteria_range1 - the group of cells the function is to search.
  • Criteria1 - determines whether the cell is to be counted or not.  
  • Criteria_range2, criteria2, ... Optional. Additional ranges and their associated criteria.

For more information about Formulas and Functions in Excel, please view the full tutorial from the CTL here: Excel Part 3

If you need further assistance, please click the CTL Support Request button on this page

 
 

CTL Support Request Print Article

Related Services / Offerings (1)

CTL Support Request
The Center for Teaching & Learning develops and supports a diverse and inclusive community dedicated to excellent teaching, learning, and student educational experience regardless of location, formality, or modality.