| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
need to assign a nomber to yes such as y=1 to run a count ? excel
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 |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
need to assign a nomber to yes such as y=1 to run a count ? ex
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 |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
need to assign a nomber to yes such as y=1 to run a count ? ex
OssieMac
Thanks that worked great and I learend about COUNTIF so once more thank you Richard "OssieMac" wrote: 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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 Add-ins - Assign Number | Excel Worksheet Functions | |||
| How can I assign delimiters to an excel web query? | Excel Discussion (Misc queries) | |||
| How do I assign a value to check box in excel | Excel Worksheet Functions | |||
| how to auto assign po numbers in Excel | Excel Worksheet Functions | |||
| In Excel how can I assign values to a Yes or No question with IF | Excel Discussion (Misc queries) | |||
Hybrid Mode
