Excel Function : COUNTIF

Download now!

Excel Function : COUNTIF

Category

Statistical

Description

Counts the number of cells within a range that meet the given criteria

Microsoft Excel Reference Page

https://support.office.com/en-us/article/COUNTIF-function-e0de10c6-f885-4e71-abb4-1f464816df34

Syntax and Description of the COUNTIF Excel Function

COUNTIF(range, criterion) The COUNTIF function in Excel counts the number of cells in a range that meet a specified criterion. range - The range of cells to be evaluated. criterion - The criterion in the form of a number, expression, or text that defines which cells will be counted.

About COUNTIF Excel Function

COUNTIF(range, criteria) The COUNTIF function returns the number of cells in a range that meet a given criteria.