View Single Post
  #1   Report Post  
pigbelly
 
Posts: n/a
Default Count how many "name" in a column


Hi

I have a problem

I have a column like:


Camera
Robot
Robot
Camera
Car
Camera


I want to extract how many Cameras I have in that column, in this case
it would be 3.
I tried to use DCOUNT but nothing happens...The syntax just get put in
the column like text no wrong messeges or anything..

/Tommie


--
pigbelly
------------------------------------------------------------------------
pigbelly's Profile: http://www.excelforum.com/member.php...o&userid=25147
View this thread: http://www.excelforum.com/showthread...hreadid=386414