Thanks Glenn...i must be missing something...below is my formula...and now i
am receiving a #NUM! error...what am i doing wrong?

=SUMPRODUCT((B:B="Sr. Marketing Mgr.")*(C:C="Redmond,
Wa")*(D:D<""))
"Glenn" wrote:

I think the assumption was that you would have named ranges for "Job_Title",
"Location" and "Candidate". If not, replace those terms in the formula with the
actual ranges of the appropriate data.


se7098 wrote:
Thanks for the response, however, i am receiving a #NAME? error

"Teethless mama" wrote:

=SUMPRODUCT((Job_Title="Sr. Marketing Mgr.")*(Location="Redmond,
Wa")*(Candidate<""))


"se7098" wrote:

i have a spreadsheet where column b contains the title of the position,
column c contains the location and column d contains the name of the
candidate.

i need to count the number of candidates based on job title and
location...each candidate has a unique name so i'm not sure how to make this
happen.

Staffing Mgr. Job Title Location Candidate
Name
Clare Duffin Sr. Marketing Mgr. Redmond, Wa Jesse Money
Clare Duffin Sr. Marketing Mgr. Redmond, Wa Frank Kemery
Clare Duffin Sr. Marketing Mgr. Redmond, Wa Chuck Mildes
Clare Duffin Sr. Marketing Mgr. Redmond, Wa Kathleen Strom
Clare Duffin Sr. Marketing Mgr. Redmond, Wa Susan Schutte
Clare Duffin Sr. Marketing Mgr. Redmond, Wa Perry Anthony
Clare Duffin Sr. Marketing Mgr. Redmond, Wa Susan Nguyen
Sr. Marketing Mgr. Total
Clare Duffin Sr. Content Mgr. Redmond, Wa Daniel Nolta
Clare Duffin Sr. Content Mgr. Redmond, Wa Eric Neuman
Clare Duffin Sr. Content Mgr. Redmond, Wa Jenni Grant
Sr. Content Mgr. Total

Is this possible? Thanks in advance for your help.