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

Related Topics

Excel HLOOKUP() Function

Excel HLOOKUP() Function The HLOOKUP() function in excel is used to search a value in the topmost row of a table and then return a corresponding value in the same column for the specified...

2 minutes read.

Excel VLOOKUP() Function

Excel VLOOKUP() Function The VLOOKUP() function in excel is used to lookup the value on the leftmost side of the table and then return the value in the corresponding row basis on the supplied...

2 minutes read.

Thermometer Chart in the Microsoft Excel

It was known that the thermometer chart is basically based on a single data point and that in turn could be used to show the achievement percentage. It primarily depends...

7 minutes read.

Notes in Excel

Notes in Excel Notes are used to include additional information to the cell and explain formulas calculation, any modification made to the cell, providing necessary information on data that is entered or to provide any...

3 minutes read.

Excel MIN() Function

Excel MIN() Function The MIN() function in excel returns the smallest or minimum value from the provided numbers, named range or array. It ignores logical values and text. Syntax MIN(Number1,Number2, ...) Parameter Number1(required)- This parameter represents the...

1 minute read.

How to create drop down in excel?

How to create drop down in excel? Drop-down lists are mostly used to facilitate data entry operations. They are commonly used in interactive websites or applications. Microsoft has expanded his Excel's data validation feature...

5 minutes read.

Adding Column in Excel

Excel spreadsheet is a combination of rows and columns. After creating the table, there is a need to insert additional row or columns. To organize a better worksheet for calculations,...

5 minutes read.

Excel LARGE() Function

The LARGE() function in excel returns the k-th largest value in a data set. Syntax LARGE (Array, kth small number from the list) Parameter Array (required)- This parameter represents the list of numbers from which nth...

1 minute read.

Excel MOD() Function

Excel MOD() Function The MOD() function in excel returns the remainder after a number is divided by a divisor Syntax MOD(number, divisor) Parameter Number(required)- This parameter represents the number which you want to divide. Divisor(required)- This parameter represents...

1 minute read.

Excel WORKDAY() Function

Excel WORKDAY() Function The WORKDAY() function in excel returns the serial number of the date before or after a specified number of workdays. Syntax WORKDAY (START_DAY, DAYS, [HOLIDAYS]) Parameter START_DAY (required)- This parameter represents the...

1 minute read.

Unique Values in Excel

The Unique function in Excel filters the list of unique values from the given data like range or array. The data presented is either number, text, date, time etc. This...

3 minutes read.

How to Make Use of the F-Test in Excel

Intro to F-Test in Microsoft Excel F-Test is primarily considered to be the essential tool of statistical in Microsoft Excel that, in turn, is used to do the hypothesis test with...

7 minutes read.

Excel SEARCH() Function

The SEARCH() function in excel finds one text value within another. It is the same, unlike FIND() function, with the only difference that it in a case-insensitive function. Syntax SEARCH (find_text, within_text, [start_num]) Parameter...

1 minute read.

Excel OFFSET () Function

Excel OFFSET () Function The OFFSET() function in excel returns range of cells that is a specified number of rows and columns from an initial specified range. Syntax OFFSET (reference, rows, cols, [height], [width]) Parameter reference(required)-...

2 minutes read.

How to use TODAY function in Excel

What is TODAY Function in Excel? Today function is one of the types of Worksheet function (WS) in Excel.Today Function belongs to the Date and Time functions.It is used to calculate...

3 minutes read.

Excel WORKDAY.INTL() Function

Excel WORKDAY.INTL() Function The WORKDAY.INTL() function in excel returns a date before or after a specified number of workdays with custom weekend parameter. Syntax WORKDAY.INTL (START_DAY, DAYS,[WEEKEND],[HOLIDAYS]) Parameter START_DAY (required)- This parameter represents the initial date...

2 minutes read.

Excel IFNA Function

Excel IFNA Function The IFNA in Excel is used to remove the #N/A type of errors in excel values cells with our choice of value. IFNA function is from Excel 2013 onwards, so it...

1 minute read.

Purpose of Randomize in Excel

Excel spreadsheets are used on a large scale for business and personal usage. It is used to store data, perform multiple calculations, make assumptions based on charts and graphs etc....

7 minutes read.

Cells and Ranges in Excel

Cells and Ranges Each cell is identified by its cell address, which is a combination of the column and row on which that cell is situated. A group of cells together are called ‘Range’. When...

5 minutes read.

How to lock cells in Excel?

How to lock cells in Excel? The locked cells feature used to protect and secure your Excel sheet or workbook from the unauthorized access. If the cells are locked, it can’t be deleted, reformatted,...

5 minutes read.