What is excel countifs function

Excel countifs function is a statistical function used to count the number of cells in multiple areas that meet given conditions. Multiple conditions can be set at the same time. This function is an extension of the countif function. It is newly added in Excel2007 and is not supported by previous versions.

#countifs function, referred to as multi-condition counting function.

Syntax

countifs(criteria_range1,criteria1,criteria_range2,criteria2,…)

Parameter description

criteria_range1: For the first cell that needs to be calculated that satisfies a certain condition number of cell ranges (referred to as condition range),

criteria1 is the condition that will be calculated in the first range (referred to as condition), and its form can be a number, expression or text. For example, the condition can be expressed as 48, "48", ">48" or "Guangzhou";

Similarly, criteria_range2 is the second condition area, criteria2 is the second condition, and so on. The final result is the number of cells in multiple ranges that meet all conditions.

Explanation

The usage of countifs is similar to countif , but countif targets a single condition, while countifs can achieve results for multiple conditions at the same time.

The above is the detailed content of What is excel countifs function. For more information, please follow other related articles on the PHP Chinese website!