# Which jobs use Microsoft Excel frequently

## FREQUENCY (function)

The FREQUENCY function calculates the number of times values occur within a range of values and then returns a vertical matrix of numbers. For example, use FREQUENCY to count exam results within specific result ranges. Since FREQUENCY returns an array, the formula must be entered as an array formula.

**FREQUENCY (dates; classes)**

The FREQUENCY function syntax has the following arguments:

**data_array**Required. Corresponds to a matrix of or a reference to a set of values whose frequencies you want to count. If "data" does not contain any values (numbers), FREQUENCY returns a matrix with zeros.**bins_array**Required. The interval limits entered as a matrix or reference to a cell range, according to which you want to classify the values contained in "Data". If "Classes" does not contain any values, FREQUENCY returns the number of elements belonging to "Data".

**Note:** If you have an up-to-date version of Microsoft 365, you can just enter the formula in the top left cell of the output range and then the **ENTER** Press to confirm the formula as a dynamic array formula. Otherwise, the formula must be entered as a conventional array formula by first selecting the output range, entering the formula in the cell in the top left of the output range, and then using **CTRL + SHIFT + ENTER** is confirmed. Excel automatically inserts curly braces at the beginning and end of the formula. For more information about array formulas, see Array Formula Guidelines and Examples.

The result matrix comprises one more element than the "classes" argument specified as a matrix or reference to a range of cells. The extra element in the returned matrix returns the number of values above the highest interval. For example, if you are counting three ranges of values (intervals) entered in three cells, make sure you enter FREQUENCY in four cells for the results. The additional cell returns the number of values in "Matrix" that are greater than the third interval value.

FREQUENCY ignores both blank cells and text.

### example

### Do you need more help?

You can always ask an expert in the Excel Tech Community, get support from the Answers Community, or suggest a new feature or improvement on Excel User Voice.

- Why are motorcycles with diesel engines unusual?
- What does audio 1
- What is meant by resistance?
- Can we send files without data
- Should I buy the Beats Studio3
- A perfect lifestyle means something
- Has conquered Denmark Groenland
- Loss of memory is a psychological disorder
- What role should men play in feminism?
- How does Gramblr offer free Instagram likes
- What is Kundalini doing
- What can heal you faster
- Why is a mega-quake of strength 20 impossible
- How do I carry out effective performance management
- Is the Vivo S1 Pro smartphone waterproof
- How did people die
- How do currency fluctuations affect banks?
- How vertical multistage pump types work
- Heat rises from the ground
- Fantasize women of three fours
- May ocean gold have turned green
- Fantasize women of three fours
- Who is Utah's Worst Enemy
- Where will the G7 2019 take place