I moved the formula to I28...now i am getting a zero which is incorrect.

would subtotals work since i am looking at multiple criteria?

i am first looking for job title, then location, then count the number of
candidates who have applied for each position.

the same job title can be in multiple locations.

Thanks for your patience and help.

"Glenn" wrote:

What cell is the formula in? It can't be in B2:B28, C2:C28 or D2:D28.

Did you try subtotals, per my other suggestion (after PivotTable)?

se7098 wrote:
changed it to:

=SUMPRODUCT((B2:B28="Sr. Marketing Mgr.")*(C2:C28="Redmond,
Wa")*(D2:D28<""))

now i am getting a circular reference error.

I guess i am missing something...just don't know what.

Thanks for all of your help.

"Glenn" wrote:

Not sure what the problem is. Make sure that you are not referencing the whole
column (named or not) and that all ranges are the same size.