J
James C
Can I write a formula in which "yes" equals 1 and "no" equals 0. So when
completed I have a sum of "yeses".
completed I have a sum of "yeses".
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
T
Teethless mama
=--(I7="yes")
James said:Try using an IF
=IF(I7="yes","1","0")
I J
7 yes 1
8 no 0
9 yes 1
E
Elkar
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
=COUNTIF(A1:A100,"yes")
This would count the number of times that "yes" appears in the range A1 thru
A100.
HTH,
Elkar
V
Vergel Adriano
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")
=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")
J
James
Try using an IF
=IF(I7="yes","1","0")
I J
7 yes 1
8 no 0
9 yes 1
=IF(I7="yes","1","0")
I J
7 yes 1
8 no 0
9 yes 1