Some thoughts to get you going
(Steps are in my xl03 - I don't have xl07 - but should be similar in xl07)

"Array-enter" basically means
to press CTRL+SHIFT+ENTER to confirm the formula
instead of just pressing ENTER

Think FREQUENCY requires you to select a multi-cell range, and then
to "array-enter" the same formula into all cells in the selected range at
one go

Give this play a try ..

Let's say the data is within A2:A10
and the bins data is in B2:B4

The formula is:
=FREQUENCY(A2:A10,B2:B5)

Copy the formula above, then
Select a columnar range of 4 cells, say select A13:A16
Click inside the formula bar, paste the formula,
then press CTRL+SHIFT+ENTER to confirm the formula
Done correctly, you should see (in the formula bar)
that Excel has inserted curly braces { } around the formula, like this:
{=FREQUENCY(A2:A10,B2:B5)}
(Re-do the steps if you don't see the curlies)

The same formula will appear in all 4* cells within A13:A16
but each cell will return the different results corresponding to the bins
range
*The extra "4th" cell returns the number of values in data
that are greater than the third interval value in B4
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Gene L." wrote in message
...
I am using Excel 2007 and wish to list the bin values (frequencies) for a
list of results.

I pressed "formulas" and then "frequencies" along with the cell
designations. I keep getting the message that the formula must be entered
as an "Array Formula". I cannot find out how to do this. Can you help?

Thanks very much:
Gene L.