There is no reason to write a bunch of SUMIF cell formulas, or do a bunch of sorting on individual columns, or FFS cut & paste data into Word to run a text search and replace on it. What the o.p. is asking for is exactly what PivotTable was designed to do, and is a trivial example of its usage. All the o.p. needs to do is select the data, go to Insert>>Recommended PivotTables, and select the option that sums on the appropriate index to get a count of each key, and then click PivotTable Analyze>>Field List to play around with fields and filters. This is probably a two or three step process and can be refreshed or repeated as the data changes with almost no effort or chance of breaking functionality.
Stranger