# FREQUENCY

## Content

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](/spreadjs/docs/v17/formulareference/FormulaFunctions/lookup-reference-functions/FORMULA_INDEX) function to get individual elements from the returned arrays.

## Data Types

Accepts an array. Returns an array.

## Examples

`FREQUENCY(A1:A7,C2:C5)`