Criteria) Range is the range where the criteria is to be applied. Example: The Criteria determines which cells are counted and is in the form of a number, an expression or a text string. The search text may also be given in the form of a regular expression. The command "b.*" is given for all words that begin with b.
If search is for literal text, enclose the text in double quotes. A1:A10 is a cell range containing the numbers to . Cell B1 contains the number . In cell B2, you enter a formula: =COUNTIF (A1:A10; ) - this returns =COUNTIF (A1:A10;B1) - this returns =COUNTIF (A1:A10;">= ") - this returns =COUNTIF (A1:A10;"<"&B1) - when B1 contains , this returns =COUNTIF (A1:A10;C2) where cell C2 contains the text > counts the number of cells in the range A1:A10 which are > .
To count only negative numbers: =COUNTIF (A1:A10;"< ") . . . - Statistical functions Figure: .
Statistical functions COUNT(Value1; Value2; ... Value30) Counts how many numbers are in the list of arguments. Text entries are normally ignored. Value1; Value2; ...
Value30 are to values or ranges representing the values to be counted. Example The entries , , and eight in the Value ... fields are to be counted. =COUNT ( ; ; ;"eight") = .
The count of numbers is therefore . Text is ignored. COUNTA(Value1; Value2; ... Value30) Counts how many values are in the list.
Text entries are also counted, even when they contain an empty string of length . Value1; Value2; ... Value30 are to arguments representing the values to be counted. Example The entries , , and eight in the Value ...
fields are to be counted. =COUNTA( ; ; ;"eight") = . The count of values is therefore . CORREL(Data1; Data2) Returns the correlation coefficient between two data sets.Data1 is the first data set.
Data2 is the second data set. Example =CORREL(A1:A20;B1:B20) calculates the correlation coefficient as a measure of the linear correlation of the two data sets. LARGE(Data; ) Returns the -th largest value in a