Introduction:-

COUNTIF function in excel is a statistical function. This function is used to count the number of cells that meet a certain single criteria. It can be used to count cells containing dates, numbers, text etc. provided they match certain criteria. This function also supports logical operators and wildcards. This is a worksheet function and can be entered into the cell in which count is required.

Syntax:-

=COUNTIF(Range, Criteria)

Arguments:-

Range:  It is the range of cells which will be used for counting.

Criteria:  It determines which cells will be counted out of the range.

Keynotes:-

• COUNTIF function can use up to 255 additional values.
• If one wants to count text values and logical values, use COUNTA function.
• COUNTIF and COUNTIFS function are used if one wants to use certain criteria for counting
• If only number values are to be counted use COUNT function.

Examples

In this example, various values are entered in Column A and Column B, and COUNTIF function is used to count values of Column A and column B having criteria (greater than 5) using the formula =COUNTIF(A4:B9, “>5”) which gives 9 as the result.