Thread: Yes No
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Elkar Elkar is offline
external usenet poster
 
Posts: 964
Default Yes No

How about using the COUNTIF function?

=COUNTIF(A1:A100,"yes")

This would count the number of times that "yes" appears in the range A1 thru
A100.

HTH,
Elkar


"James C" wrote:

Can I write a formula in which "yes" equals 1 and "no" equals 0. So when
completed I have a sum of "yeses".