O'Reilly logo

Microsoft® Excel® 2010 Formulas & Functions Inside Out by Helmut Reinke Egbert Jeschke Sara Unverhau, Eckehard Pfeifer, Bodo Fienitz, and Jens Bock

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

COUNTIFS()

Note

The COUNTIFS() function was new in Excel 2007.

Syntax. COUNTIFS(criteria_range1,criteria1,criteria_range2,criteria2,...)

Definition. This function counts the number of cells in a range meeting several criteria.

Arguments

  • criteria_range1 (required). The range in which to evaluate the associated criteria. The cells in the range have to be cell names, cell arrays, or references to cells containing numbers. Empty cells and text values are ignored.

  • criteria1 (required). The criteria in the form of numbers, expressions, cell references, or text that define which cells will be counted.

  • criteria_range2 (optional). One to 127 ranges in which the criteria has to be evaluated. The cells in the ranges have to be cell names, cell arrays, or references ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required