Conditional execution
Thanks Dave -
"Dave Peterson" wrote:
Oopsie...
=CountIf("Your range here", "yes")
Vacation's Over wrote:
It's easier than that
=CountIf("YES", "Your range here")
this function will return the number of "Yes" cells in your range
"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
"yes" means the values in the cells
"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...
--
Dave Peterson
|