Excel
CountIfs is a built-in statistical function. It can also be used as a worksheet
function in addition to other formulas in a cell of a worksheet.
Syntax
=countIfs(
criteria_range_1, criteria_1, criteria_range_2, criteria_2,
…..criteria_range_n, criteria_n)
Arguments
- Criteria_range_n. Range of cells that you want to apply against criteria_n
- Criteria_n. The criteria used to determine which cells to count.
Where
n=1,2,3,4,5….
Purpose
To
count a number of cells in a range that meets a single or multiple criteria
Return
Type
Numeric
Remarks
- Each additional range must have the same number of rows and columns as in the first range
- Both contiguous and non contiguous ranges are allowed
- If the criteria is a reference to an empty cell, the countifs function treats it as zero
No comments:
Post a Comment