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