In column B I have multiple categories with the total number of people in each category in parenthesis next to the abbreviated category, e.g. FP(3). There are multiple categories with their totals in one cell, separated by a comma. Column A has the location type.
I need to be able to count the total number of people for each category by location from the entire column. Attached is a spreadsheet for an example.
Bookmarks