convert drop down text into result

P

PeterHad

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
 
J

JulieD

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
 
P

Peo Sjoblom

You don't need to display it as number 1, you can use

=COUNTIF(Range,"Yes")


Regards,

Peo Sjoblom
 
Top