# how do I find an average number of specific words in a column

1. ## how do I find an average number of specific words in a column

I am attempting to calculate a number of specific word occurrences. In
example, I have a column with yes in certain cells, and no in the others.
How can I display the total number of yes and no occurrences? I am fairly
new to Excel and know very little about coding in it.

2. ## Re: how do I find an average number of specific words in a column

Hi

you can use the countif function to return the numbers of "yes" and "no"
e.g.
=COUNTIF(A1:A100,"yes")
will count the number of "yes" answers in the range A1 to A100
likewise,
=COUNTIF(A1:A100,"no")
will count the number of "no" answers in the same range

Hope this helps
Cheers
JulieD

"cashgrfx" <cashgrfx@discussions.microsoft.com> wrote in message
>I am attempting to calculate a number of specific word occurrences. In
> example, I have a column with yes in certain cells, and no in the others.
> How can I display the total number of yes and no occurrences? I am fairly
> new to Excel and know very little about coding in it.

3. ## Re: how do I find an average number of specific words in a column

Of course, I meant countif

--
Don Guillett
SalesAid Software
donaldb@281.com
"cashgrfx" <cashgrfx@discussions.microsoft.com> wrote in message
> I am attempting to calculate a number of specific word occurrences. In
> example, I have a column with yes in certain cells, and no in the others.
> How can I display the total number of yes and no occurrences? I am fairly
> new to Excel and know very little about coding in it.

4. ## Re: how do I find an average number of specific words in a column

Have a look in HELP index for SUMIF

--
Don Guillett
SalesAid Software
donaldb@281.com
"cashgrfx" <cashgrfx@discussions.microsoft.com> wrote in message
> I am attempting to calculate a number of specific word occurrences. In
> example, I have a column with yes in certain cells, and no in the others.
> How can I display the total number of yes and no occurrences? I am fairly
> new to Excel and know very little about coding in it.

5. ## Re: how do I find an average number of specific words in a column

Thank You very much!! However, I have another question now, is there a way
to show Yes = ? (the number returned by the countif statement) in the cell
with the statment? In other words, instead of just the value showing in the
cell, can I add a "Yes =" and the value appear after the "=" sign? Thanks
again!!

"JulieD" wrote:

> Hi
>
> you can use the countif function to return the numbers of "yes" and "no"
> e.g.
> =COUNTIF(A1:A100,"yes")
> will count the number of "yes" answers in the range A1 to A100
> likewise,
> =COUNTIF(A1:A100,"no")
> will count the number of "no" answers in the same range
>
> Hope this helps
> Cheers
> JulieD
>
> "cashgrfx" <cashgrfx@discussions.microsoft.com> wrote in message
> >I am attempting to calculate a number of specific word occurrences. In
> > example, I have a column with yes in certain cells, and no in the others.
> > How can I display the total number of yes and no occurrences? I am fairly
> > new to Excel and know very little about coding in it.

>
>
>

6. ## Re: how do I find an average number of specific words in a column

Hi

generally it's best to put the Yes in another cell e.g. B1 and the COUNTIF
formula in say C1 and then you can use
=COUNTIF(A1:A100,B1)

however, if you want to put it in the same cell and you don't mind the
number of yes answers being treated as text rather than a number you can do
this
="Yes = " & COUNTIF(A1:A100,"Yes")

Hope this helps
Cheers
JulieD

"cashgrfx" <cashgrfx@discussions.microsoft.com> wrote in message
news:742892B9-47FD-49E3-8525-0C018C361ACD@microsoft.com...
> Thank You very much!! However, I have another question now, is there a
> way
> to show Yes = ? (the number returned by the countif statement) in the cell
> with the statment? In other words, instead of just the value showing in
> the
> cell, can I add a "Yes =" and the value appear after the "=" sign? Thanks
> again!!
>
> "JulieD" wrote:
>
>> Hi
>>
>> you can use the countif function to return the numbers of "yes" and "no"
>> e.g.
>> =COUNTIF(A1:A100,"yes")
>> will count the number of "yes" answers in the range A1 to A100
>> likewise,
>> =COUNTIF(A1:A100,"no")
>> will count the number of "no" answers in the same range
>>
>> Hope this helps
>> Cheers
>> JulieD
>>
>> "cashgrfx" <cashgrfx@discussions.microsoft.com> wrote in message
>> >I am attempting to calculate a number of specific word occurrences. In
>> > example, I have a column with yes in certain cells, and no in the
>> > others.
>> > How can I display the total number of yes and no occurrences? I am
>> > fairly
>> > new to Excel and know very little about coding in it.

>>
>>
>>

7. ## Re: how do I find an average number of specific words in a column

You have been extremely helpfull!! Thank you!!

"JulieD" wrote:

> Hi
>
> generally it's best to put the Yes in another cell e.g. B1 and the COUNTIF
> formula in say C1 and then you can use
> =COUNTIF(A1:A100,B1)
>
> however, if you want to put it in the same cell and you don't mind the
> number of yes answers being treated as text rather than a number you can do
> this
> ="Yes = " & COUNTIF(A1:A100,"Yes")
>
> Hope this helps
> Cheers
> JulieD
>
> "cashgrfx" <cashgrfx@discussions.microsoft.com> wrote in message
> news:742892B9-47FD-49E3-8525-0C018C361ACD@microsoft.com...
> > Thank You very much!! However, I have another question now, is there a
> > way
> > to show Yes = ? (the number returned by the countif statement) in the cell
> > with the statment? In other words, instead of just the value showing in
> > the
> > cell, can I add a "Yes =" and the value appear after the "=" sign? Thanks
> > again!!
> >
> > "JulieD" wrote:
> >
> >> Hi
> >>
> >> you can use the countif function to return the numbers of "yes" and "no"
> >> e.g.
> >> =COUNTIF(A1:A100,"yes")
> >> will count the number of "yes" answers in the range A1 to A100
> >> likewise,
> >> =COUNTIF(A1:A100,"no")
> >> will count the number of "no" answers in the same range
> >>
> >> Hope this helps
> >> Cheers
> >> JulieD
> >>
> >> "cashgrfx" <cashgrfx@discussions.microsoft.com> wrote in message
> >> >I am attempting to calculate a number of specific word occurrences. In
> >> > example, I have a column with yes in certain cells, and no in the
> >> > others.
> >> > How can I display the total number of yes and no occurrences? I am
> >> > fairly
> >> > new to Excel and know very little about coding in it.
> >>
> >>
> >>

>
>
>

8. ## Re: how do I find an average number of specific words in a column

you're welcome
"cashgrfx" <cashgrfx@discussions.microsoft.com> wrote in message
news:4788BD12-9531-4D29-935E-A2CD3FBE7B69@microsoft.com...
> You have been extremely helpfull!! Thank you!!
>
> "JulieD" wrote:
>
>> Hi
>>
>> generally it's best to put the Yes in another cell e.g. B1 and the
>> COUNTIF
>> formula in say C1 and then you can use
>> =COUNTIF(A1:A100,B1)
>>
>> however, if you want to put it in the same cell and you don't mind the
>> number of yes answers being treated as text rather than a number you can
>> do
>> this
>> ="Yes = " & COUNTIF(A1:A100,"Yes")
>>
>> Hope this helps
>> Cheers
>> JulieD
>>
>> "cashgrfx" <cashgrfx@discussions.microsoft.com> wrote in message
>> news:742892B9-47FD-49E3-8525-0C018C361ACD@microsoft.com...
>> > Thank You very much!! However, I have another question now, is there a
>> > way
>> > to show Yes = ? (the number returned by the countif statement) in the
>> > cell
>> > with the statment? In other words, instead of just the value showing
>> > in
>> > the
>> > cell, can I add a "Yes =" and the value appear after the "=" sign?
>> > Thanks
>> > again!!
>> >
>> > "JulieD" wrote:
>> >
>> >> Hi
>> >>
>> >> you can use the countif function to return the numbers of "yes" and
>> >> "no"
>> >> e.g.
>> >> =COUNTIF(A1:A100,"yes")
>> >> will count the number of "yes" answers in the range A1 to A100
>> >> likewise,
>> >> =COUNTIF(A1:A100,"no")
>> >> will count the number of "no" answers in the same range
>> >>
>> >> Hope this helps
>> >> Cheers
>> >> JulieD
>> >>
>> >> "cashgrfx" <cashgrfx@discussions.microsoft.com> wrote in message
>> >> >I am attempting to calculate a number of specific word occurrences.
>> >> >In
>> >> > example, I have a column with yes in certain cells, and no in the
>> >> > others.
>> >> > How can I display the total number of yes and no occurrences? I am
>> >> > fairly
>> >> > new to Excel and know very little about coding in it.
>> >>
>> >>
>> >>

>>
>>
>>

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1