Parameter List
Syntax
COUNTIFS(range1, criterion1,
[range2, criterion2]
)range1
A range of values you want to count. For example: A1:A5.
criterion1
The pattern or test to apply to range1. For example: 5, ">5", or "spreadsheet".
[optional] range2
An additional range of values you want to count. Size must be the same as range1. For example: B1:B5.
More details
You can use wildcards in criterion. To match any singular character, use ?. To match zero or more characters, use *. If you want to match an actual question mark or asterisk, prefix it with a tilde. For example: "What~?".
If criterion is a number, each cell in range is checked to see if it is equal to criterion. If you want to use operators, such as > or >=, you need to enclose your criterion in quoatation marks.
Examples
