# How to use Excel COUNTIFS function

## SUMMARY INFO

All the basic information regarding Excel 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

## EXCEL COUNTIFS FUNCTION DETAILS

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

### =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:

Here we provide a list of useful links which we think can be useful while trying to learn the COUNTIFS Excel 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: