Counting specified words in a column - macro if possible
 

Looking to count the number of times say the following words appear in
column 1
Mouse
Ant
Pig

Is there a code that will count each of these individually
so I can then offset the results into another column?

Grateful for advice
John

Counting specified words in a column - macro if possible
 

Hi John

=COUNTIF(A:A,"mouse")
=COUNTIF(A:A,"ant")
=COUNTIF(A:A,"pig")

Cheers
JulieD

"John Hayden" wrote in message
...
Looking to count the number of times say the following words appear in
column 1
Mouse
Ant
Pig

Is there a code that will count each of these individually
so I can then offset the results into another column?

Grateful for advice
John