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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

richard V - 24 Oct 2007 01:36 GMT

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

Reply to this Message

OssieMac - 24 Oct 2007 01:55 GMT

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

> 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

Reply to this Message

OssieMac - 24 Oct 2007 02:08 GMT

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

Reply to this Message

richard V - 24 Oct 2007 15:27 GMT

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

> Hi again Richard,
>
[quoted text clipped - 12 lines]
>
> OssieMac

Reply to this Message