+ Reply to Thread
Results 1 to 3 of 3

Surveys and percentages

  1. #1
    Registered User
    Join Date
    07-31-2006
    Posts
    2

    Surveys and percentages

    Hi, I'm new to this forum and I'm having a problem with excel which sounds very simple, yet I can't solve it.
    Imagine this: I'm holding a survey in which I ask people if they smoke. These are the results I see in Excel:

    Person1: Yes
    Person2: Yes
    Person3: No
    Person4: Yes
    Person5: Yes
    Person6: No
    Person7: No
    Person8: Yes

    Where Person1, Person2, Person3 etc are in cells A1, A2, A3, etc and the answers are each in a cell B1, B2, B3, etc. So basically, the cells in column A contain the persons, and the cells in column B contain Yes or No.
    Now I want to know how many percent of the total amount of replies is Yes, and how many is No. So if lets say 10 persons replied, from which 7 replied Yes, and 3 replied No, we would have 70% of Yes and 30% of no, except that in reality, my survey has more possible replies, and way more people having replied to it...

    Anyone can help me? I need to calculate these percentages, and might I also add I'd need to know it asap
    I thank anyone who can help me in advance.

  2. #2
    David Biddulph
    Guest

    Re: Surveys and percentages

    "Dr.Boo" <[email protected]> wrote in
    message news:[email protected]...
    >
    > Hi, I'm new to this forum and I'm having a problem with excel which
    > sounds very simple, yet I can't solve it.
    > Imagine this: I'm holding a survey in which I ask people if they smoke.
    > These are the results I see in Excel:
    >
    > Person1: Yes
    > Person2: Yes
    > Person3: No
    > Person4: Yes
    > Person5: Yes
    > Person6: No
    > Person7: No
    > Person8: Yes
    >
    > Where Person1, Person2, Person3 etc are in cells A1, A2, A3, etc and
    > the answers are each in a cell B1, B2, B3, etc. So basically, the cells
    > in column A contain the persons, and the cells in column B contain Yes
    > or No.
    > Now I want to know how many percent of the total amount of replies is
    > Yes, and how many is No. So if lets say 10 persons replied, from which
    > 7 replied Yes, and 3 replied No, we would have 70% of Yes and 30% of
    > no, except that in reality, my survey has more possible replies, and
    > way more people having replied to it...
    >
    > Anyone can help me? I need to calculate these percentages, and might I
    > also add I'd need to know it asap
    > I thank anyone who can help me in advance.


    =COUNTIF(B1:B8,"Yes")/COUNTA(B1:B8)
    and =COUNTIF(B1:B8,"No")/COUNTA(B1:B8)
    and format as a percentage.
    --
    David Biddulph



  3. #3
    Registered User
    Join Date
    07-31-2006
    Posts
    2
    Thanks a lot. I will try that out right away.

+ 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