Finding the sum of yes/no answers

T

tony

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
 
A

Alan Beban

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sum of yes answers 2
Help with this formula please. 1
Can I get help with this formula please. 1
Output from Frames - multiple optionbutton groups 1
Finding last appearance of given value 6
Get/Find criteria and copy sum 2
"Merging" Yes/No Fields in a query (MSAccess 2007) 4
Questions and input boxes 1

Top