how to count specific item???

J

Jeff32

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
 
D

Don Guillett

You could make a list of the numbers and in the next column
=countif(a:a,b1) copy down to number 39
assuming the numbers you want to count are in col a and the numbers to
evaluate are in col b
 
G

Gord Dibben

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
 
Top