• Share
Send to a Friend via Email

Your suggestion is on its way!

An email with a link to:

was emailed to:

Thanks for sharing About.com with others!

Excel COUNTIFS Function Step by Step Tutorial

3 of 9

The COUNTIFS Function's Syntax

Excel COUNTIFS Function Step by Step Tutorial

The COUNTIFS Function's Syntax

In Excel, a function's syntax refers to the layout of the function and includes the function's name, brackets, and arguments.

The syntax for the COUNTIFS function is:

= COUNTIFS ( Criteria_range1, Criteria1, Criteria_range2, Criteria2, ...)

Up to 127 Criteria_range / Criteria pairs can be specified in the function.

The COUNTIFS Function's Arguments

The function's arguments tell COUNTIFS what criteria we are trying to match and what range of data to search to find these criteria.

All arguments in this function are required.

Criteria_range - the group of cells the function is to search for a match to the corresponding Criteria argument.

Criteria - the value we are trying to match in the data record. Actual data or the cell reference to the data can be entered for this argument.

Ted French