Spread Formula Reference
Formula Functions / Functions D to G / FREQUENCY
In This Topic
    FREQUENCY
    In This Topic

    This function calculates how often values occur within a range of values. This function returns a vertical array of numbers.

    Syntax

    FREQUENCY(dataarray,binarray)

    Arguments

    This function has these arguments:

    Argument Description
    dataarray Array of values or a reference to a set of values for which to count frequencies
    binarray Array of intervals or a reference to intervals into which to group the values of dataarray

    Remarks

    The number of elements in the returned array is one greater than the number of elements in binarray. The extra element in the returned array is the count of values in dataarray that is above the highest value in binarray.

    Use the INDEX function to get individual elements from the returned arrays.

    Data Types

    Accepts an array. Returns an array.

    Examples

    FREQUENCY(A1:A7,C2:C5)

    Version Available

    This function is available in product version 2.0 or later.

    See Also

    AVEDEV | AVERAGEA | CONFIDENCE | DEVSQ | MEDIAN | VAR | Statistical Functions