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

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

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