Thread: need to assign a nomber to yes such as y=1 to run a count ? excel
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
OssieMac OssieMac is offline
external usenet poster
  
Posts: 2,510
Default need to assign a nomber to yes such as y=1 to run a count ? excel
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



"richard V" wrote:

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 With QuoteReply With Quote