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".
|