# How to use Excel COUNTIF function

## SUMMARY INFO

All the basic information regarding COUNTIF function in Excel is listed in the table below. (This data is regularly updated from Microsoft and several resources)

 Function: COUNTIF Function Category: Statistical Description: Counts the number of cells within a range that meet the given criteria Return Value: A number representing cells counted. Syntax: =COUNTIF (range, criteria) Applies to: Excel 2016, Excel 2013, Excel 2011 for Mac, Excel 2010, Excel 2007, Excel 2003, Excel XP, Excel 2000 Other languages: English: COUNTIF French: NB.SI German: ZÄHLENWENN Spanish: CONTAR.SI Dutch: AANTAL.ALS Italian: CONTA.SE Russian: СЧЁТЕСЛИ Danish: TÆL.HVIS Swedish: ANTAL.OM Portuguese (Brazil): CONT.SE Polish: LICZ.JEŻELI Finnish:  LASKE.JOS Norwegian: ANTALL.HVIS Portuguese (Portugal): CONTAR.SE Czech: COUNTIF Hungarian: DARABTELI Turkish: EĞERSAY All Other Languages: COUNTIF Related Functions: COUNT, COUNTIFS

## FUNCTION DETAILS

Syntax details with an example regarding the correct usage of COUNTIF formula can be seen below.

### =COUNTIF (range, criteria)

range The range of cells to count.
criteria The criteria that controls which cells should be counted.

## VIDEO EXAMPLES

Check the video below to see How to use COUNTIF function in Excel with some examples:

Here we provide a list of useful links which we think can be useful while trying to learn the COUNTIF function in Excel usage with some examples and tips.

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

Excel COUNTIF function examples: