need to assign a nomber to yes such as y=1 to run a count ? excel

[richard V]

Iam working on a project with excel 2003, and I am trying to assign a vale
you to yes "yes = 1" and "no = 2" and then good back and add up the yes and
no.

help I have look for about 3hr and cant work it out?
thanks for any ones help

 

[OssieMac]

Hi Richard,

What about using COUNTIF. Assuming that Ye and No are in range A1:A30:-


=COUNTIF(,"Yes")

or

=COUNTIF(A1:A30,"No")

Regards,

OssieMac

 

[OssieMac]

Hi again Richard,

last post is corrupted, Not sure what I did or didn't do. Here is second try.


What about using COUNTIF. Assuming that Yes and No are in range A1:A30:-


=COUNTIF(A1:A30,"Yes")

or

=COUNTIF(A1:A30,"No")

Regards,

OssieMac

 

[richard V]

OssieMac
Thanks that worked great and I learend about COUNTIF
so once more thank you
Richard