The FREQUENCY() function returns the value that is above the nth percentile of a set of values. The syntax for the function is FREQUENCY (data_array, bins_array). The argument "data_array" can be numerical values, references to a range of cells or a named range of which you want to count the frequency each value occures and the "bins_array" are the categories (interbvals) you want to sort the data values into. The frequency function serves to count and order how may data values fall between the defined intervals. For example FREQUCEY({1,2,3,2,5,4,4,5,7,8,9}, {3,8,10})= {4,6,2} To learn more about frequency in mathematics see: [The Frequency Mathematics Knowledgebase]

How to use the FREQUENCY() function: Type " =FREQUENCY( " Enter the reference for the "data_array" "A2:A10". Type a comma. Enter the refencence for the "bin_array" "B2:B4 ". Type ")" then press the "Enter" key.

Note: If the arrays contain non numeric elements they will be ignored by the FREQUENCY function.