How to use Excel COUNTIFS function
All the basic information regarding Excel COUNTIFS function is listed in the table below. (This data is regularly updated from Microsoft and several resources)
|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
|Portuguese (Brazil): CONT.SES
Portuguese (Portugal): CONTAR.SE.S
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.|
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 COUNTIFS Excel function usage with some examples and tips.
Microsoft Office support page – Excel COUNTIFS function:
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: