Countif or Something Else?

[Guest]

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

 

[Guest]

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

 

[Guest]

Thank you, you have saved me hours of work! Again, many thanks Angie

 

[Don Guillett]

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