Excel COUNTIFS() Function
Excel COUNTIFS() Function
The COUNTIFS() function in excel is used to count the numbers within a range that meet the supplied criteria.
Syntax
COUNTIFS (range1, criteria1, [range2], [criteria2], ...)
Parameter
Range1 (required)- This parameter represents the range of cells that we need the criteria to evaluate.
Criteria1 (required)- This parameter refers to the condition which you want to check and then count the cells based on it.
Range2 (optional)- This parameter represents the second range of cells that we need the criteria to evaluate.
Criteria2 (optional)- This parameter refers to the second condition which you want to check and then count the cells based on it.
Category
Statistical
Return
This function returns the count of a number of cells, which consist of numbers and meet a given criterion.
Example 1
Objective: Using COUNTIFS function, count the number of products having a price between $300 and $500 in the following table.
Emp ID | Purchased Date | Product Category | Product | Unit | Amount |
E001 | 21-Mar-18 | Camera | ASUS F556UA | 2 | $548 |
E002 | 22-Mar-19 | Laptop | Canon ES | 2 | $500 |
E003 | 13-Aug-18 | Watch | Fitbit Blaze Smart Watch | 1 | $73 |
E004 | 24-Mar-13 | Laptop | Samsung Gear S2 | 4 | $950 |
E005 | 2-Jun-11 | Watch | Fitbit Blaze Smart Watch | 3 | $198 |
E006 | 2-Jan-12 | Camera | Pebble Smart Watch | 4 | $306 |
E007 | 27-Mar-18 | Watch | Apple Watch Sport | 2 | $308 |
E008 | 28-Mar-15 | Laptop | ASUS F556UA | 3 | $529 |
E009 | 29-Mar-18 | Watch | HP 15-ay011nr | 2 | $499 |
E010 | 20-Sep-18 | Laptop | ASUS ROG | 1 | $1,099 |
Result | Formula Text |
3 | =COUNTIFS(G215:G225,">=400",G215:G225,"<=500") |