yes/no option - adding up responses

**LordVido** · 06-22-2006, 08:13 PM

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

Don Guillett · 06-22-2006, 08:55 PM

have a look in the help index for COUNTIF

--
Don Guillett
SalesAid Software
[email protected]
"LordVido" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

Gord Dibben · 06-22-2006, 09:40 PM

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
<[email protected]> 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

**LordVido** · 06-23-2006, 12:26 AM

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?