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


--
Hope that helps.

Vergel Adriano


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