Try using an IF

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

I J
7 yes 1
8 no 0
9 yes 1



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