Try this:

In cell E2 type: =Countif($B2:$D2,"Yes")

Then copy this down col E as far as needed.

"raja" wrote:

i want to substitue 1 for "yes" and 0 for "no"

then i want to add up all the 1's to a variable and display in the column E

"cush" wrote:

if (yes) then c=1 and it should be added to column E
for all rows...

If WHAT = "yes"

and WHAT should be added to column E?

and when you say "c=1", do you mean that you want to
change the value of the "yes" or "no" in column c of that row to a "1"?

You need to be much more specific in phrasing your question.

"raja" wrote:

i have 100*100 cells..
which look like
A B C D
x yes no yes
y yes yes no
z no no no

if (yes) then c=1 and it should be added to column E
for all rows...