+ Reply to Thread
Results 1 to 3 of 3

Excel 2007 : want to assign numeric values to a drop down box

  1. #1
    Registered User
    Join Date
    05-25-2011
    Location
    baltimore
    MS-Off Ver
    Excel 2007
    Posts
    3

    want to assign numeric values to a drop down box

    I have been searching everywhere. I made a drop down box that says yes and no. I need yes to equal 1 and populate the number of yes's in one column. Can someone please help!

  2. #2
    Forum Expert tigeravatar's Avatar
    Join Date
    03-25-2011
    Location
    Colorado, USA
    MS-Off Ver
    Excel 2003 - 2013
    Posts
    5,361

    Re: want to assign numeric values to a drop down box

    goose1,

    It sounds like you want to count the number of "Yes" or "No" entries in a column (depending on what you have selected from your drop down list) and display the total.

    For your spreadsheet, i'm imagining the following:
    Questions in column A
    Yes/No entries in column B
    Row 1 has headers
    The drop-down list is a cell containing a validation list. That drop-down list is in cell C2

    Using that setup, you could put the following formula in cell D2:
    =IF(C2="","",COUNTIF(B:B,C2))

    If this is not correct, or you are looking for something different, please provide more information and/or a sample workbook so that we can better help you.

    ~tigeravatar

  3. #3
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,898

    Re: want to assign numeric values to a drop down box

    You can just use COUNTIF

    e.g.

    =COUNTIF(A1:A100,"Yes")

    This counts the number of Yes's in A1:A100
    Where there is a will there are many ways.

    If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner

    Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1