COUNTIFS Function

Basic Description

The Excel Countifs function returns the number of entries (within one or more supplied arrays), that satisfy a set of given criteria. The function is new in Excel 2007, and so is not available in earlier versions of Excel.

Syntax: COUNTIFS( criteria_range1, criteria1, [criteria_range2, criteria2], … )

Where the function arguments are as follows:

criteria_range1
[criteria_range2], …
Arrays of values (or ranges of cells containing values) to be tested against the respective criteria1, criteria2, …(The supplied criteria_range arrays must all have the same length)
criteria1,
[criteria2], …
The conditions to be tested against the values in criteria_range1, [criteria_range2], …

Up to 127 pairs of criteria_range and criteria arguments can be supplied to the function. Note that if your criteria is a text string or an expression, this must be supplied to the function in quotes. Also note that the Excel Countifs function is not case-sensitive. So, for example, the text strings “TEXT” and “text” will be considered to be equal.

 

Excel Countifs Function Examples

Countifs function example-1

Formulas:

Count_Formulas_1

Results:

Count_Result_1

 

Countifs function example-2

Formulas:

Countifs_Formulas

Results:

Countifs_Result

 

Countifs Function Errors

The error that you are most likely to get from the Excel Countifs function is the #VALUE! error  occurs if the supplied criteria_range arrays do not all have equal length.

 

Download Documents

Download Excel File

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

*

code

clearPost Comment