Using COUNTIF with 2 criteria - SUMPRODUCT?

[Mike R.]

Greetings,
I would like to COUNTIF with 2 criteria and I have read on how to use
SUMPRODUCT to accomplish this. However, I am still getting a pretty #NUM!
error in the calculation. Here is my formula:

=SUMPRODUCT(--('Turnover Details by HR Group'!D=A4),--('Turnover Details
by HR Group'!B:B=$B$2))

Please help. Thank you,
Mike

 

[Jason Morin]

SUMPRODUCT nor array formulas can handle entire column
references. Rather than using D, use something like
D12000.

HTH
Jason
Atlanta, GA

 

[Mike R.]

Perfect... I thought there was something wierd like that, I just couldn't
remember or find it in the newsgroup. Thanks!