Jeff

The FREQUENCY Function is tailor-made for this operation.

The column is the Data Array

An adjacent column with the numbers 11-39 is the Bins Array.

Note: this is an Array function so output cells must be pre-selected and CTRL +
SHIFT + ENTER used to enter the formula.


Gord Dibben MS Excel MVP

On Sun, 7 May 2006 10:53:19 -0500, Jeff32
wrote:


Howdy all,
I have a column that contains a specific number in each cell,
the numbers are 11 thru 39. Each number represents an area I deliver
to.
How can I count how many times each specific number is displayed in the
column, so I can see how many times I delivered to that area.
Thanks for any help!
Jeff