# FREQUENCY

Spread for WinForms provides advanced software components that support Excel import/export, full cell customization, an extensive calculation engine with over 450 functions and more, all with zero dependencies on Excel.

## 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](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsFtoK/FunctionINDEX) 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](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsAtoC/FunctionAVEDEV) \| [AVERAGEA](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsAtoC/FunctionAVERAGEA) \| [CONFIDENCE](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsAtoC/FunctionCONFIDENCE) \| [DEVSQ](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsDtoG/FunctionDEVSQ) \| [MEDIAN](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsMtoQ/FunctionMEDIAN) \| [VAR](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsTtoZ/FunctionVAR) \| [Statistical Functions](/spreadnet/docs/latest/online-formula/formulas-overview/formulas-functs/formulas-functtypes/formulas-functsstats)