Thread
:
how to count specific item???
View Single Post
#
2
Posted to microsoft.public.excel.misc
Don Guillett
Posts: n/a
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
Reply With Quote