Converting yes / no to 1 or 0

[teiben]

Help.
I have created a column with a few list boxes with yes or no into them. I need the yes or no to somehow = 0 or 1. In the column there are other numbers which need to be summed so the CountIF(a1:a11,"yes") will not work. ANy ideas?

 

[Brianwarnock]

Do you mean that you want something like
=Countif(a1:a11,"yes")+sum(a1:a11)

Brian

 

[teiben]

the countif(xxx:ccc,"yes") will not work since in the column(s) there are other values

I.e.
ColumnA ColumnB
Yes no
Yes yes
no 40
yes no
38 no

I need a to sum to 41 and column b to sum to 40

 

[Brianwarnock]

Just tried it , it works for me.

Brian

 

[teiben]

Does work, except that I didnt' mention that only the 1st, 3rd, 5th, 7 etc (all odd number rows and all even number rows then they need to be divied) number in each column needs to be added, so I need the yes and no to return values.