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



ADVERTISEMENT
ADVERTISEMENT