Microsoft Office Tutorials and References
In Depth Information
The CRITERIA argument is the criteria in the form of a number, expression, or text that
defines which cells will be counted. Whatever you decide to use in this argument, Excel must
be able to convert it into a Boolean (TRUE/FALSE) expression that defines the criteria.
The second argument of the COUNTIF function also can accept a range of data. An outstanding
example of using this range argument is in the formula that returns the count of unique
items in a rectangular range. The COUNTIF function can be used to count those items
individually, as indicated by the formulas in B5:B14 (formula shown for B1) in Figure 10.11. However,
the array formula in E9 is able to perform this calculation in a collective manner. The formula
as shown in the figure is an array formula. To enter an array formula, press Ctrl+Shift+Enter.
The key part of this formula is 1/COUNTIF(B5:B14, B5:B14) , which affords an array of ratios,
which evaluates as shown below.
So, if an item appears three times in the range A1:A10, as indicated by the use of the COUNTIF
function in column B, the array will contain three occurrences of the value.
The range of cells to count.
The criteria in the form of an expression. Such as “>10”.
The COUNTIF function
can be used in an array
formula to calculate
the number of unique
items in a range.
The DEGREES function converts radians into degrees.
The ANGLE argument is the angle in radians that you want to convert. Using this function is
equivalent to multiplying a value in radians by 180/PI(). The formula DEGREES(PI()) equals
180 because pi radians describes an arc of a hemisphere.