Hi Everyone -
Im completely new here - first post, so dont bite.

What im looking to do is get a count of items that are dependent across columns. For example: I have various Job Titles in Column A, and various Status in Column B.

I need to know how many times there is a Facilities Manager (Column A) at Rejected (Column B).

Ive been working with SUMPRODUCTS, but the totals dont accurately reflect what is in the raw data, so i think im missing something here.

This is what i currently have.

=SUMPRODUCT(('2013 Candidates'!F2:F500="Facilities Manager")*('2013 Candidates'!M2:M500="Rejected"))

Thanks for any help!