ExcelBanter - Yes No

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Yes No (https://www.excelbanter.com/excel-discussion-misc-queries/136628-yes-no.html)

James C

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

Teethless mama

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

Elkar

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

Vergel Adriano

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

James

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

All times are GMT +1. The time now is 03:04 PM.