Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Finding the sum of yes/no answers
I have a checklist which can have 3 answers; Yes, No, or
Quesionable. these three answers are contained each in their own colum. Is there a way to sum these so that at the bottom of the colum i can have a numeric total for each colum. The letters entered for the answers are "Y", "N", and "?". for example Y QUESTION 1 Y QUESTION 2 N QUESTION 3 ? QUESTION 4 Y QUESTION 5 N QUESTION 6 N QUESTION 7 ? QUESTION 8 3 3 2 TOTALS |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Finding the sum of yes/no answers
look in HELP index for SUMIF
"tony" wrote in message ... I have a checklist which can have 3 answers; Yes, No, or Quesionable. these three answers are contained each in their own colum. Is there a way to sum these so that at the bottom of the colum i can have a numeric total for each colum. The letters entered for the answers are "Y", "N", and "?". for example Y QUESTION 1 Y QUESTION 2 N QUESTION 3 ? QUESTION 4 Y QUESTION 5 N QUESTION 6 N QUESTION 7 ? QUESTION 8 3 3 2 TOTALS |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Finding the sum of yes/no answers
Assuming your data is in A11:D18 and there is no data in A1:D10,
enter in A20 and fill across to C20 =COUNTA(A1:A18) Alan Beban tony wrote: I have a checklist which can have 3 answers; Yes, No, or Quesionable. these three answers are contained each in their own colum. Is there a way to sum these so that at the bottom of the colum i can have a numeric total for each colum. The letters entered for the answers are "Y", "N", and "?". for example Y QUESTION 1 Y QUESTION 2 N QUESTION 3 ? QUESTION 4 Y QUESTION 5 N QUESTION 6 N QUESTION 7 ? QUESTION 8 3 3 2 TOTALS |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sum of yes answers | Excel Worksheet Functions | |||
multiple answers | Excel Worksheet Functions | |||
Please help me with answers | Excel Discussion (Misc queries) | |||
using formula with several possible answers | Excel Worksheet Functions | |||
Does anyone know the answers to | Links and Linking in Excel |