-
Solved: How Do I Count?
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
-
Alan,
=COUNTIF(C9:C25,"yes")
Doesn't care about case (Caps) or other words.
Cheers,
dr
-
Thanks dr
As easy as that? Just the job.
Alan
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules