Assuming that your data is in 2 columns, E and F (to separate them from your
ABC and XYZ locations/titles in the formulas) and goes from row 2 to row 100:
=SUMPRODUCT(--(E2:E100="A"),--(F2:F100="X"))
Will give you number of job title X's at Location A. Just change the "A"
and "X" for each pairing.

" wrote:

Must be a COUNTIF or similar function
DATA is LOCATION (A, B, C) and JOB TITLE (X, Y, Z)
I figured how to get the # of people at each SITE (using COUNTIF)
Need to figure out how to have subsets of this...Operators, Foremen,
Supervisors at Site A, and the same for SIte B, etc...
It can't be that hard.
Thanks