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

Getting Radio Buttons to work, that are inserted via AutoText 0
Get/Find criteria and copy sum 2
Compute Additional Hours Needed Using "if" or "lookup" 1
Page numbering with Merged Document and IF statements 1
Would like to input 3 letters into a cell, each having a different numerical value 5
Outlook mail shared questions 0
Help with this formula please. 1
Can I get help with this formula please. 1

Top