PDA

View Full Version : Solved: How Do I Count?



drums4monty
11-23-2006, 02:32 AM
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
11-23-2006, 03:13 AM
Alan,

=COUNTIF(C9:C25,"yes")

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

Cheers,

dr

drums4monty
11-23-2006, 03:42 AM
Thanks dr

As easy as that? Just the job.

Alan