Skip to main content

COUNTIF generally refers to a worksheet function within a spreadsheet program that counts cells in a range based on a specified condition. This tag can also be used for COUNTIFS, which provides a similar function but allows multiple ranges and criteria.

Syntax

=COUNTIF(range, criteria)

range (required) - The group of cells you want to count. Range can contain numbers, arrays, or references that contain numbers. Blank and text values are ignored.

Criteria (required) - A number, expression, cell reference, or text string that determines which cells will be counted.

Microsoft KB for countif

Microsoft KB for countifs

Open Office countif documentation