Skip to main content
Windward

FREQUENCY Function

Overview

The FREQUENCY function calculates how often values occur within a range of values.

 

 

For example

=Frequency(Range(79,85,78,85,50,81,95,88,97),Range(70,79,89)) returns [1,2,4,2]

Syntax

FREQUENCY(data_range,bin_range)
  • ​data_range - Required. An array of  set of values for which you want to count frequencies.
  • bin_range - Required. An array of  intervals into which you want to group the values in data_range.
  • Was this article helpful?