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 |
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 |
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 |
All times are GMT +1. The time now is 11:45 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com