View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Don Guillett
 
Posts: n/a
Default 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