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

1. ## 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

2. ## 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.

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

Thank you so much. This works wonderfully.

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