COUNTIFS(range1, criteria1,range2, criteria2...) counts the number of cells within a range that meet multiple criteria : COUNTIFS « Statistical functions « Microsoft Office Excel 2007 Tutorial






  1. Microsoft Office Excel 2007 Tutorial
  2. Statistical functions
  3. COUNTIFS
Input the formula: =COUNTIFS(B2:D10,"=5"). Press Enter to get the result.
Input the formula: =COUNTIFS
21.15.COUNTIFS
21.15.1.COUNTIFS(range1, criteria1,range2, criteria2...) counts the number of cells within a range that meet multiple criteriaCOUNTIFS(range1, criteria1,range2, criteria2...) counts the number of cells within a range that meet multiple criteria
21.15.2.=COUNTIFS(B2:B5,"=Yes",C2:C5,"=Yes")=COUNTIFS(B2:B5,