+ Reply to Thread
Results 1 to 3 of 3

Count values in one list and then narrow/combine values based on criteria

  1. 12-12-2013, 11:19 PM #1
    razz0807
    razz0807 is offline
    Registered User
    Join Date
    05-13-2010
    Location
    New Brunwsick, Canada
    MS-Off Ver
    Excel 2013
    Posts
    22

    Count values in one list and then narrow/combine values based on criteria

    I am stumped. Been staring at this and know I should be able to figure this out but I am stuck.

    I have a large list with values in a specific column that I want to count. There are 20+ possible unique values for this column (expected to increase over time). I want to group the count of values according to a table where the values are matched up to a summary value. For example 4 of the values may be combined into one for reporting, while some may be reported without combining with other values. Or in other words, I would like to take the 20+ values and sum them up into logical groupings so that I only need to report on 5 values (for example).

    Example attached.

    Thank you in advance to any assistance.Book1 - Copy.xlsx
    Reply With QuoteRegister To Reply
  2. 12-12-2013, 11:27 PM #2
    benishiryo
    benishiryo is offline
    Forum Guru benishiryo's Avatar
    Join Date
    03-25-2011
    Location
    Singapore
    MS-Off Ver
    Excel 2013
    Posts
    5,147

    Re: Count values in one list and then narrow/combine values based on criteria

    hi razz. 1 way could be this array formula:
    =SUM(COUNTIF($B$4:$B$11,IF($F$4:$F$9=I4,$E$4:$E$9)))

    ...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer. Press F2 on that cell and try again.

    Thanks, if you have clicked on the * and added our rep.

    If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".

    "Contentment is not the fulfillment of what you want, but the realization of what you already have."

    Tips & Tutorials I Compiled | How to Get Quick & Good Answers
    Reply With QuoteRegister To Reply
  3. 12-13-2013, 08:02 AM #3
    razz0807
    razz0807 is offline
    Registered User
    Join Date
    05-13-2010
    Location
    New Brunwsick, Canada
    MS-Off Ver
    Excel 2013
    Posts
    22

    Re: Count values in one list and then narrow/combine values based on criteria

    Thank you so much. This works wonderfully.
    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. Count unique values (in an ever expanding list) based on criteria
    By Greed in forum Excel General
    Replies: 2
    Last Post: 09-28-2011, 08:43 AM
  2. Count unique values and create list based on these values
    By vipa2000 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 06:05 PM
  3. Count unique values and create list based on these values
    By vipa2000 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 03:05 PM
  4. [SOLVED] Count unique values and create list based on these values
    By vipa2000 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 02:05 AM
  5. Count unique values and create list based on these values
    By vipa2000 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 AM

Tags for this Thread

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