Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

How do I add the 'yes' answers in a column using Microsoft Excel?

Discussion in 'Information Technology' started by nana, Jul 28, 2006.

  1. nana

    nana
    Expand Collapse
    Guest

    This has been bugging me for nights. I do not know what function to use or
    formula to total the number of 'yes' answers in a column using Microsoft
    Excel. I only know how to total numbers in Excel but not the text. I am
    making a marketing report of clients whom we called and one of the colums has
    a heading of Enrollment. Answers to this column can either be Yes or No.
    How do i total the number of 'Yes' or enrolled clients at the end of the
    column. PLEASE HELP!! SOS!!!
    --
    NANA
     
  2. Loading...


  3. Ofer Cohen

    Ofer Cohen
    Expand Collapse
    Guest

    You have posted your question in Microsoft Access Discussion group, there is
    a Discussion group dedicated to Microsoft Excel at this link:

    http://www.microsoft.com/office/com...?dg=microsoft.public.excel.misc&lang=en&cr=US

    --
    Good Luck
    BS"D


    "nana" wrote:

    > This has been bugging me for nights. I do not know what function to use or
    > formula to total the number of 'yes' answers in a column using Microsoft
    > Excel. I only know how to total numbers in Excel but not the text. I am
    > making a marketing report of clients whom we called and one of the colums has
    > a heading of Enrollment. Answers to this column can either be Yes or No.
    > How do i total the number of 'Yes' or enrolled clients at the end of the
    > column. PLEASE HELP!! SOS!!!
    > --
    > NANA
     
  4. John Vinson

    John Vinson
    Expand Collapse
    Guest

    On Mon, 10 Jul 2006 08:43:01 -0700, nana
    <nana@discussions.microsoft.com> wrote:

    >This has been bugging me for nights. I do not know what function to use or
    >formula to total the number of 'yes' answers in a column using Microsoft
    >Excel. I only know how to total numbers in Excel but not the text. I am
    >making a marketing report of clients whom we called and one of the colums has
    >a heading of Enrollment. Answers to this column can either be Yes or No.
    >How do i total the number of 'Yes' or enrolled clients at the end of the
    >column. PLEASE HELP!! SOS!!!


    You're asking in the wrong place. This newsgroup is not for Excel;
    it's for a different program, Microsoft Access. Please scroll down the
    list of subject areas and repost in an Excel support area.

    You should be able to use the IF() function to get a 1 for "yes" and a
    0 for "no" answers, and sum that up. See the online help for IF.

    John W. Vinson[MVP]
     
  5. BobMartin776

    BobMartin776
    Expand Collapse
    Guest

    "nana" wrote:

    > This has been bugging me for nights. I do not know what function to use or
    > formula to total the number of 'yes' answers in a column using Microsoft
    > Excel. I only know how to total numbers in Excel but not the text. I am
    > making a marketing report of clients whom we called and one of the colums has
    > a heading of Enrollment. Answers to this column can either be Yes or No.
    > How do i total the number of 'Yes' or enrolled clients at the end of the
    > column. PLEASE HELP!! SOS!!!
    > --
    > NANA


    Use the COUNTIF function in Excel: =COUNTIF(CellRange,"Yes")
    where CellRange is the range of cells you want to include in your search.
    Check for complete details in Excel help.
    Bob
     

Share This Page