1. Technology
You can opt-out at any time. Please refer to our privacy policy for contact information.

Excel COUNTIFS Function Step by Step Tutorial

By

3 of 9

The COUNTIFS Function's Syntax
Excel COUNTIFS Function Step by Step Tutorial

Excel COUNTIFS Function Step by Step Tutorial

© Ted French

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.

©2014 About.com. All rights reserved.