Yes No

[Guest]

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

 

[Guest]

=--(I7="yes")

Try using an IF

=IF(I7="yes","1","0")

I J
7 yes 1
8 no 0
9 yes 1

 

[Guest]

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

 

[Guest]

This will give you a 1 if A1 is Yes, and 0 otherwise.
=IF(A1="Yes", 1, 0)

This will give you a count of cells in Column A where the cell value is
equal to "Yes"
=COUNTIF(A:A,"Yes")

 

[Guest]

Try using an IF

=IF(I7="yes","1","0")

I J
7 yes 1
8 no 0
9 yes 1