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

try



=COUNTIF(A1:A10,"camera")

where a1:a10 is the range where your data is held.


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

Oki

as always I get a error:

I wrote this
=COUNTIF(B4:B8,"Kamera")

and got "the formula you typed contains an error"
This happens to me often, even if I paste stuff from the help meny!


/Tommie


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

Used the insert function tool

=COUNTIF(B4:B8;"Kamera")

I see now that I missed the ";" I had a ,

sorry

and thank you

/Tommie


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

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