+ Reply to Thread
Results 1 to 4 of 4

Count a value from a group of values

  1. 01-30-2017, 03:27 PM #1
    redJohn89
    redJohn89 is offline
    Registered User
    Join Date
    07-11-2016
    Location
    usa
    MS-Off Ver
    2016
    Posts
    78

    Count a value from a group of values

    Hi,
    I am trying to find out a way to count the values in Column A of my attached sheet from Column C. My expected output is Col B.
    Is there a way to count this in excel?
    Thanks in advance for your help
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 01-30-2017, 03:39 PM #2
    Tony Valko
    Tony Valko is offline
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Count a value from a group of values

    Try this...

    This formula entered in B2 and copied down:

    =SUMPRODUCT(LEN(";"&C$2:C$8&";")-LEN(SUBSTITUTE(";"&C$2:C$8&";",A2,"")))/LEN(A2)
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.
    Reply With QuoteRegister To Reply
  3. 01-30-2017, 04:04 PM #3
    redJohn89
    redJohn89 is offline
    Registered User
    Join Date
    07-11-2016
    Location
    usa
    MS-Off Ver
    2016
    Posts
    78

    Re: Count a value from a group of values

    Thanks Tony...that worked !
    Reply With QuoteRegister To Reply
  4. 01-30-2017, 05:27 PM #4
    Tony Valko
    Tony Valko is offline
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Count a value from a group of values

    You're welcome. Thanks for the feedback!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Sort and group names, then sum associated numerical values for each group, sort total
    By Joe Dren in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-18-2014, 05:54 PM
  2. [SOLVED] Count values in one list and then narrow/combine values based on criteria and count those
    By razz0807 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-21-2014, 02:53 PM
  3. Need to group and get the total page count per Group - Example attached - Please HELP!!
    By jazzy7010 in forum Excel General
    Replies: 8
    Last Post: 01-09-2014, 08:01 PM
  4. How do I sort/group/count/sum/subtotal and have each group put into a different workbook?
    By Kim Jarema in forum Excel General
    Replies: 1
    Last Post: 10-19-2012, 07:55 AM
  5. Using values from one group of cells to format a separate group of cells
    By cyne in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-17-2011, 04:05 AM
  6. [SOLVED] Count Distinct Values by Group Using Pivot Table (NM)
    By MCP in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-11-2005, 06:06 PM
  7. [SOLVED] count a group of numbers but do not count duplicates
    By Lisaml in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-26-2005, 08: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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1