| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Yes No
Can I write a formula in which "yes" equals 1 and "no" equals 0. So when
completed I have a sum of "yeses". |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Yes No
=--(I7="yes")
"James" wrote: 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". |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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". |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Yes No
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". |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Yes No
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". |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
