# 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")