PC Review


Reply
Thread Tools Rate Thread

How can I count the # of times the word "Yes" appears in a range

 
 
=?Utf-8?B?TWVyaQ==?=
Guest
Posts: n/a
 
      7th Jul 2006

 
Reply With Quote
 
 
 
 
Bearacade
Guest
Posts: n/a
 
      7th Jul 2006

Assuming your range is A1:B10

=COUNTIF(A1:B10, "YES"

--
Bearacad

-----------------------------------------------------------------------
Bearacade's Profile: http://www.excelforum.com/member.php...fo&userid=3501
View this thread: http://www.excelforum.com/showthread.php?threadid=55945

 
Reply With Quote
 
Gord Dibben
Guest
Posts: n/a
 
      7th Jul 2006
=COUNTIF(A1:G23,"Yes")


Gord Dibben MS Excel MVP

On Fri, 7 Jul 2006 11:19:01 -0700, Meri <(E-Mail Removed)> wrote:


 
Reply With Quote
 
=?Utf-8?B?TWVyaQ==?=
Guest
Posts: n/a
 
      7th Jul 2006
thank you so much for your prompt respononse

"Bearacade" wrote:

>
> Assuming your range is A1:B10
>
> =COUNTIF(A1:B10, "YES")
>
>
> --
> Bearacade
>
>
> ------------------------------------------------------------------------
> Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016
> View this thread: http://www.excelforum.com/showthread...hreadid=559451
>
>

 
Reply With Quote
 
=?Utf-8?B?TWVyaQ==?=
Guest
Posts: n/a
 
      7th Jul 2006
thank you so much for your prompt respononse

"Gord Dibben" wrote:

> =COUNTIF(A1:G23,"Yes")
>
>
> Gord Dibben MS Excel MVP
>
> On Fri, 7 Jul 2006 11:19:01 -0700, Meri <(E-Mail Removed)> wrote:
>
>
>

 
Reply With Quote
 
=?Utf-8?B?TWVyaQ==?=
Guest
Posts: n/a
 
      7th Jul 2006
thank you so much for your prompt respononse

"Bearacade" wrote:

>
> Assuming your range is A1:B10
>
> =COUNTIF(A1:B10, "YES")
>
>
> --
> Bearacade
>
>
> ------------------------------------------------------------------------
> Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016
> View this thread: http://www.excelforum.com/showthread...hreadid=559451
>
>

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Count the number of times a specific date appears in a range of ce Louisa Microsoft Excel Worksheet Functions 6 19th May 2009 05:26 PM
Count the number of times a specific date appears in a range of ce Louisa Microsoft Excel Worksheet Functions 0 19th May 2009 11:50 AM
How do I count how many times the same word occurs or appears ? =?Utf-8?B?T2N0b2Jlcm9u?= Microsoft Word Document Management 5 9th Nov 2008 12:38 AM
Count how many times a word appears, even not at all crystal_xyz@hotmail.com Microsoft Access Queries 4 3rd Mar 2006 05:05 AM
COUNT: Counting the number of times "X" comes up after the occurrence of "Y" DrSues02 Microsoft Excel Misc 5 3rd Aug 2004 06:35 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 05:38 PM.