Adding like values, per entry, from a data set generated from 2 spill arrays, whose data source is a table

So, I've run two unique functions and then a sumifs function to generate a frequency counter for events happening at a location per person.

Problem is, the "location" is actually 3 diffrent sites, (some are 2, some are 1). The site to location actually has it's own table.

What I'm trying to do is write a function that adds like locations togeather to give a summed total of location incidents per individual, not site totals (because the individuals move between sites).

The original table has 20k entries with 20 fields each, and over 300 unique individuals across 9 sites (4 locations) so hard coding is not exactly time allowable.