Count how many "name" in a column

[pigbelly]

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]

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]

Used the insert function tool

=COUNTIF(B4:B8;"Kamera")

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

sorry

and thank you

/Tommie

 

[Bob Phillips]

Just use COUNTIF

=COUNTIF(A:A,"Camera")

--

HTH

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