convert drop down text into result

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
You don't need to display it as number 1, you can use

=COUNTIF(Range,"Yes")


Regards,

Peo Sjoblom
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Drop down / validation / lookup into the same cell 2
drop down's 2
If then on drop down 1
Select drop down menu option using libre-calc macro 0
drop down list and adding numeric values to text 2
Data Validation - Cell Colour 3
Filtered drop down list 2
Drop Down menu's 2

Back
Top