Counting specified words in a column - macro if possible

J

John Hayden

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
 
J

JulieD

Hi John

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

Cheers
JulieD
 
Top