+ Reply to Thread
Results 1 to 5 of 5

yes/no option - adding up responses

  1. #1
    Registered User
    Join Date
    06-22-2006
    Posts
    3

    Question yes/no option - adding up responses

    Hi

    I have created a workbook with 4 sheets that are basically the same. I want to be know how to do the following:

    1. I have a column of cells (all sheets) that I want the inputer to only be able to type "yes" or "no" in. (or leave blank).
    2. I have a cell that I want to total only the "yes" answers on the sheet the cell resides.
    3. I also have a cell that I want to total only the "yes" answers on ALL sheets.

    Any help with this would be very appreciated.
    Thanks in advance

    -LV

  2. #2
    Don Guillett
    Guest

    Re: yes/no option - adding up responses

    have a look in the help index for COUNTIF

    --
    Don Guillett
    SalesAid Software
    dguillett1@austin.rr.com
    "LordVido" <LordVido.29twez_1151021701.4022@excelforum-nospam.com> wrote in
    message news:LordVido.29twez_1151021701.4022@excelforum-nospam.com...
    >
    > Hi
    >
    > I have created a workbook with 4 sheets that are basically the same. I
    > want to be know how to do the following:
    >
    > 1. I have a column of cells (all sheets) that I want the inputer to
    > only be able to type "yes" or "no" in. (or leave blank).
    > 2. I have a cell that I want to total only the "yes" answers on the
    > sheet the cell resides.
    > 3. I also have a cell that I want to total only the "yes" answers on
    > ALL sheets.
    >
    > Any help with this would be very appreciated.
    > Thanks in advance
    >
    > -LV
    >
    >
    > --
    > LordVido
    > ------------------------------------------------------------------------
    > LordVido's Profile:
    > http://www.excelforum.com/member.php...o&userid=35696
    > View this thread: http://www.excelforum.com/showthread...hreadid=554803
    >




  3. #3
    Gord Dibben
    Guest

    Re: yes/no option - adding up responses

    Assuming column B on each sheet holds the yes/no answers.

    I reserved Column A for the questions.

    On all sheets in C1 enter =COUNTIF(B1:B200,"yes")

    This counts yesses on each sheet in Column B

    On sheet1 in D1 enter =SUM(Sheet1:Sheet4!C1)

    This totals all yesses from all sheets.


    Gord Dibben MS Excel MVP

    On Thu, 22 Jun 2006 19:13:09 -0500, LordVido
    <LordVido.29twez_1151021701.4022@excelforum-nospam.com> wrote:

    >
    >Hi
    >
    >I have created a workbook with 4 sheets that are basically the same. I
    >want to be know how to do the following:
    >
    >1. I have a column of cells (all sheets) that I want the inputer to
    >only be able to type "yes" or "no" in. (or leave blank).
    >2. I have a cell that I want to total only the "yes" answers on the
    >sheet the cell resides.
    >3. I also have a cell that I want to total only the "yes" answers on
    >ALL sheets.
    >
    >Any help with this would be very appreciated.
    >Thanks in advance
    >
    >-LV



  4. #4
    Registered User
    Join Date
    06-22-2006
    Posts
    3
    Thank you, that was very helpful, but a couple questions.

    1. Is there a way to make it so ONLY yes or no can be input into those cells? In fact, I would like it to auto fill with yes when a Y is typed; n for no if possible.

    2. on =SUM(Sheet1:Sheet4!C1) is that literal or do I replace "Sheet1" with the names of my sheets?
    Last edited by LordVido; 06-23-2006 at 12:30 AM.

  5. #5
    Registered User
    Join Date
    06-22-2006
    Posts
    3
    Ok I figured it all out. thanks again.

+ 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