counting drop down box entries
 

"i have a column which is filled using entries from data validation dro
down boxes.
I've tried to count how many of each entry is in the column, but th
normal countif function won't work....Can you put me in the righ
direction?

thanks

--
M3Cob
-----------------------------------------------------------------------
M3Cobb's Profile: http://www.excelforum.com/member.php...fo&userid=2498
View this thread: http://www.excelforum.com/showthread.php?threadid=56370

counting drop down box entries
 

A pivot table would be an easy way to do this. Give your column of data a
heading at the top, select all the data, then select Pivot Table and Pivot
Chart Report from the Data menu. Drag/add your field to the Row fields area
and also to the Data items area. By default, the pivot table should give you
a count of each entry.

Hope this helps,

Hutch

"M3Cobb" wrote:


"i have a column which is filled using entries from data validation drop
down boxes.
I've tried to count how many of each entry is in the column, but the
normal countif function won't work....Can you put me in the right
direction?

thanks"


--
M3Cobb
------------------------------------------------------------------------
M3Cobb's Profile: http://www.excelforum.com/member.php...o&userid=24986
View this thread: http://www.excelforum.com/showthread...hreadid=563702