i-nth logo
How to use FREQUENCY function
1 June 2013

FREQUENCY(data_array, bins_array)

Calculates how often values occur within a range of values and then returns a vertical array of numbers having one more element than the bins_array:

  • data_array - is an array of or reference to a set of values for which you want to count frequencies.
  • bins_array - is an array of or reference to intervals into which you want to group the values in the data_array.

Full article: How to use FREQUENCY function

Consulting

We can help you make better spreadsheets:

  • Reviewing your spreadsheets for errors.
  • Advice about improving your spreadsheets.
  • Training in spreadsheet good practice.

Contact us