Home |
Search |
Today's Posts |
#1
|
|||
|
|||
convert drop down text into result
I Have created a drop down box with Yes,No in it, this will be used multiple
times to collate information, if yes is selected i want it to represent the number 1 and be diplayed as number 1 in a seperate sheet,this is the same for "no" i then want to be able to add up the yes's & no's for each queastion which, so i need to know how i can keep a running total many thanks |
#2
|
|||
|
|||
Hi
in your other sheet you can use a formula such as =IF(Sheet1!A1="yes",1,0) which will display 1 for yes values and 0 for everything else or =IF(Sheet1!A1="yes",1,IF(Sheet1!A1="no",0,"")) you can then add up these numbers using the SUM function However, you can also use the COUNTIF function to count the number of yes and no without coverting them to 1 and 0 respectively =COUNTIF(A1:A10,"yes") will give you the number of yes within the range A1:A10 likewise =COUNTIF(A1:A10,"no") hope this helps cheers JulieD "PeterHad" wrote in message ... I Have created a drop down box with Yes,No in it, this will be used multiple times to collate information, if yes is selected i want it to represent the number 1 and be diplayed as number 1 in a seperate sheet,this is the same for "no" i then want to be able to add up the yes's & no's for each queastion which, so i need to know how i can keep a running total many thanks |
#3
|
|||
|
|||
You don't need to display it as number 1, you can use
=COUNTIF(Range,"Yes") Regards, Peo Sjoblom "PeterHad" wrote: I Have created a drop down box with Yes,No in it, this will be used multiple times to collate information, if yes is selected i want it to represent the number 1 and be diplayed as number 1 in a seperate sheet,this is the same for "no" i then want to be able to add up the yes's & no's for each queastion which, so i need to know how i can keep a running total many thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
link to result from drop down list | Links and Linking in Excel | |||
Convert text to numbers | Excel Discussion (Misc queries) | |||
Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) | |||
how do I easily convert a single column of text (multiple rows si. | Excel Discussion (Misc queries) | |||
Convert text file to MS_Excel | Excel Discussion (Misc queries) |