The 2 arrays are the data_array and the bins_array.

The data_array is the array of numbers you want to analyze.

The bins_array is an array of intervals into which you want to group the
values from the data_array.

For example:

Data array.....Bins array
7...................10
40.................20
41.................30
63.................40
67.................50

FREQUENCY performs a series of counts based on the intervals of the
bins_array.

Bins array
10...counts number of values that are <=10
20...counts number of values that are 10 but <=20
30...counts number of values that are 20 but <=30
40...counts number of values that are 30 but <=40
50...counts number of values that are 40 but <=50

Now comes the confusing part. FREQUENCY adds 1 more bin than those listed in
the bins_array. This last bin is for any values that are 50. So, when you
enter the formula you need to enter it to a total number of cells that
equals the number of bins +1.

In this example we have 5 bins listed (10,20,30,40,50) so you need to select
a total of 6 cells then enter the formula as an array.

Based on this sample the results would be:

Data.....Bins.....Formula result
7..........10.......1 = 1 value is <=10
40........20.......0 = 0 values are 10 but <=20
41........30.......0 = 0 values are 20 but <=30
63........40.......1 = 1 value is 30 but <=40
67........50.......1 = 1 value is 40 but <=50
........................2 = 2 values are 50



--
Biff
Microsoft Excel MVP


"Danni2004" wrote in message
...
Can someone please clarify the difference between the two arrays you need
for
a FREQUENCY function?

Thanks