Solved: How Do I Count?

[drums4monty]

I need to count a certain word in a column. I can count the words using Count or CountA etc. The range of the Column is C9:c25 and the users will either leave it blank, or put in No or no or Yes or yes. I want to be able to count just the Yes or yes.

Can any one help please?

Alan

[rbrhodes]

Alan,

=COUNTIF(C9:C25,"yes")

Doesn't care about case (Caps) or other words.

Cheers,

dr

[drums4monty]

Thanks dr

As easy as that? Just the job.

Alan