+ Reply to Thread
Results 1 to 6 of 6

Count individual entries in a list

  1. #1
    Registered User
    Join Date
    08-12-2014
    Location
    Longwood Fl
    MS-Off Ver
    2013
    Posts
    3

    Count individual entries in a list

    What I am having trouble with is after making a data validation list in a column, I need to count each separate list entry and display it in a "totals" column. The drop down list has 4 entries yes, no, blank, and pending. The formula must count which value has been selected from the list and return it to a cell same as the COUNTA. I.E. 100 rows in the SS 50 are yes, 25 are no, 20 are pending, and 5 are blank.

    Any help with this would be appreciated tremendously!

  2. #2
    Registered User
    Join Date
    07-22-2014
    Location
    Riyadh
    MS-Off Ver
    2010
    Posts
    88

    Re: Count individual entries in a list

    example with attachmnt please

  3. #3
    Registered User
    Join Date
    08-12-2014
    Location
    Longwood Fl
    MS-Off Ver
    2013
    Posts
    3

    Re: Count individual entries in a list

    Here is a marked up PDF showing you what I am referring to.
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    07-22-2014
    Location
    Riyadh
    MS-Off Ver
    2010
    Posts
    88

    Re: Count individual entries in a list

    Please Login or Register  to view this content.
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by mohamedJamsheer; 08-12-2014 at 11:37 AM.

  5. #5
    Registered User
    Join Date
    07-22-2014
    Location
    Riyadh
    MS-Off Ver
    2010
    Posts
    88

    Re: Count individual entries in a list

    is your problem solved?

  6. #6
    Registered User
    Join Date
    08-12-2014
    Location
    Longwood Fl
    MS-Off Ver
    2013
    Posts
    3

    Re: Count individual entries in a list

    Yes it was. I was afraid that it was going to be that easy. Thank You

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 5
    Last Post: 10-17-2014, 09:58 AM
  2. Using VBA: I have a list with multiple entries.Need to reduce down to unique entries
    By welchs101 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 05-25-2011, 03:19 PM
  3. trouble aggregating individual entries into statistics
    By bserpico in forum Excel General
    Replies: 4
    Last Post: 07-24-2010, 10:45 AM
  4. Separate multiple entries in cell to individual cells
    By Jim15 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-14-2005, 12:04 PM
  5. [SOLVED] Hyperlink for a group of addresses without individual entries?
    By Peter R in forum Excel General
    Replies: 1
    Last Post: 02-09-2005, 10:06 PM

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