FREQUENCY(data_array, bins_array)

Returns the number of times a particular value occurs in a list, table or cell range.

data_arrayThe array containing the values you want to use.
bins_arrayThe array containing the intervals you want to group by.


* This function always returns an array.
* This function must be entered as an array formula.
* If "data_array" contains no values then an array of zeros is returned.
* If "bins_array" contains no values then the "data_array" array is returned.
* The arguments can be cell ranges that evaluate to numbers ??
* This must be entered as an array formula, using (Ctrl + Shift + Enter) - is entered as an array formula after you select a range of adjacent cells into which you want the returned distribution to appear.
* The number of elements in the returned array is one more than the number of elements in "bins_array".
* The extra element in the returned array returns the count of any values above the highest interval. For example, when counting three ranges of values (intervals) that are entered into three cells, be sure to enter FREQUENCY into four cells for the results.
* The extra cell returns the number of values in "data_array" that are greater than the third interval value.
* Blank cells or cells containing text are ignored.
* Formulas that return arrays must be entered as array formulas.
* You can use the MODE.SNGL function to return the value that occurs most frequently.
* For the Microsoft documentation refer to

1=FREQUENCY({1,1,2,2,3,2,1},{1,2}) = 3
2=FREQUENCY({1,1,2,2,3,2,1},{1,2,3,4}) = 3
3=FREQUENCY({1,1,2,2,3,2,1},{3}) = 7
4=FREQUENCY(A1:A9,C4:C6) equals {0;2;5;2}

© 2021 Better Solutions Limited. All Rights Reserved. © 2021 Better Solutions Limited Top