One column has unit locations at a facility and an array of three columns has
"qualifications" meeting other criteria of events at same facility. Each row
represents an "unique identity". Need to create a formula that only counts a
particular "unit location" if it shares the same row ("unique identity") that
meets a particular "qualification" appearing among other "qualifications"
within the three column array. Example: Count (get a sum of) only the
"unique identities" that are in room "A" (unit location) and which wear the
color black (qualifications). In other words, if "A" matches cells in same
row that contain "black", what is the sum of "A's".