+ Reply to Thread
Results 1 to 8 of 8

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

  1. #1
    cashgrfx
    Guest

    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. #2
    JulieD
    Guest

    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
    news:BDACBFAD-D4D2-42C3-9D71-DEE94D52B5AB@microsoft.com...
    >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. #3
    Don Guillett
    Guest

    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
    news:BDACBFAD-D4D2-42C3-9D71-DEE94D52B5AB@microsoft.com...
    > 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. #4
    Don Guillett
    Guest

    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
    news:BDACBFAD-D4D2-42C3-9D71-DEE94D52B5AB@microsoft.com...
    > 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. #5
    cashgrfx
    Guest

    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
    > news:BDACBFAD-D4D2-42C3-9D71-DEE94D52B5AB@microsoft.com...
    > >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. #6
    JulieD
    Guest

    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
    >> news:BDACBFAD-D4D2-42C3-9D71-DEE94D52B5AB@microsoft.com...
    >> >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. #7
    cashgrfx
    Guest

    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
    > >> news:BDACBFAD-D4D2-42C3-9D71-DEE94D52B5AB@microsoft.com...
    > >> >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. #8
    JulieD
    Guest

    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
    >> >> news:BDACBFAD-D4D2-42C3-9D71-DEE94D52B5AB@microsoft.com...
    >> >> >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.
    >> >>
    >> >>
    >> >>

    >>
    >>
    >>




+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Bookmarks

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