View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
tony[_2_] tony[_2_] is offline
external usenet poster
 
Posts: 1
Default 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