How to use Excel COUNTIF Function


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.


=COUNTIF(Range, Criteria)


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.


  • 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.


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.

Leave a Comment

Your email address will not be published. Required fields are marked *