skip to Main Content

How to use Excel COUNTIFS function

SUMMARY INFO

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

Function: COUNTIFS
Function Category: Statistical
Description: Counts the number of cells within a range that meet multiple criteria
Return Value: The number of times criteria are met
Syntax: =COUNTIFS (range1, criteria1, [range2], [criteria2], …)
Applies to: Excel 2016, Excel 2013, Excel 2011 for Mac, Excel 2010, Excel 2007
Other languages: English: COUNTIFS
French: NB.SI.ENS
German: ZÄHLENWENNS
Spanish: CONTAR.SI.CONJUNTO
Dutch: AANTALLEN.ALS
Italian: CONTA.PIÙ.SE
Russian: СЧЁТЕСЛИМН
Danish: TÆL.HVISER
Swedish: ANTAL.OMF
Portuguese (Brazil): CONT.SES
Polish: LICZ.WARUNKI
Finnish: LASKE.JOS.JOUKKO
Norwegian: ANTALL.HVIS.SETT
Portuguese (Portugal): CONTAR.SE.S
Czech: COUNTIFS
Hungarian: DARABHATÖBB
Turkish: ÇOKEĞERSAY
All Other Languages: COUNTIFS
Related Functions: COUNT, COUNTIF

 

FUNCTION DETAILS

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

how-to-use-excel-COUNTIFS-function

=COUNTIFS (range1, criteria1,  [range2], [criteria2], …)

range1 The first range to evaulate.
criteria1 The criteria to use on range1.
range2 [optional] The second range to evaluate.
criteria2 [optional] The criteria to use on range2.

 

VIDEO EXAMPLES

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

 

LINKS AND RESOURCES

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

Microsoft Office support page – Excel COUNTIFS function:
https://support.office.com/en-us/article/COUNTIFS-function-dda3dc6e-f74e-4aee-88bc-aa8c2a866842

 

EXCEL FORMULAS TRAINER

As said: Practice Makes Perfect!

Test your Excel skills in Excel itself with our unique product: Excel Formulas Trainer.

30 sections and around 100 questions with full hands-on experience. Progress tracking, dashboard, error checking and many more. Check it now:

someka excel formulas full trainer inpost