not too clear but
=sumproduct((a2:a22="a")*(b2:b22="black")) to count
=sumproduct((a2:a22="a")*(b2:b22="black")*c2:c22)t o sum c based on criteria

--
Don Guillett
SalesAid Software

"Psalm91jim" wrote in message
...
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".