You could have found that by looking in the help index for COUNTIF.

--
Don Guillett
SalesAid Software

"Angiewelly" wrote in message
...
Thank you, you have saved me hours of work! Again, many thanks Angie

"steve_doc" wrote:

Ensure that the criteria you are trying to count is encased in ""
eg. "OG"

"Angiewelly" wrote:

I am trying to count a colomn I3:I197 and only need to count the cells
that
contain the text OG. I have tried CountIf but I am getting nowhere. Can
anyone help please?

Thanks

Angie