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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
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
 
OssieMac
Thanks that worked great and I learend about COUNTIF
so once more thank you
Richard
 
Back
Top