how to count specific item???
 

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


--
Jeff32
------------------------------------------------------------------------
Jeff32's Profile: http://www.excelforum.com/member.php...o&userid=34204
View this thread: http://www.excelforum.com/showthread...hreadid=539655

how to count specific item???
 

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

--
Don Guillett
SalesAid Software

"Jeff32" wrote in
message ...

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


--
Jeff32
------------------------------------------------------------------------
Jeff32's Profile:
http://www.excelforum.com/member.php...o&userid=34204
View this thread: http://www.excelforum.com/showthread...hreadid=539655

how to count specific item???
 

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