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