Count how many "name" in a column

P

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
 
P

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
 
P

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
 
B

Bob Phillips

Just use COUNTIF

=COUNTIF(A:A,"Camera")

--

HTH

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