Just use COUNTIF

=COUNTIF(A:A,"Camera")

--

HTH

RP
(remove nothere from the email address if mailing direct)


"pigbelly" wrote in
message ...

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