Another thing of note, the way I sent the original spreadsheet is how it is already setup.....with multiple tabs. Each tab is used to track one individual investigator and then how many cases they work. So each investigator will have different types of incidents for different jurisdictions but they will overlap and thus the need to get totals across multiple tabs.

So, I will look to see if I can set it up with one master sheet that will pull all Incident Types across all tabs for specific cities (jurisdictions).

I'm guessing this will be a little more involved than getting totals from one tab like you have setup.

The original spreadsheet has many other columns that I did not show because those are columns that don't need to be sorted or counted.

Someone at work also mentioned Pivot Tables but they don't know enough about them to help......they just know enough to throw the term out at me.