Using COUNTIF with 2 criteria - SUMPRODUCT?

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:D=A4),--('Turnover Details
by HR Group'!B:B=$B$2))

Please help. Thank you,
Mike

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

HTH
Jason
Atlanta, GA

>-----Original Message-----
>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:D=A4),--
('Turnover Details
>by HR Group'!B:B=$B$2))
>
>Please help. Thank you,
>Mike
>.
>

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


"Jason Morin" wrote:

> SUMPRODUCT nor array formulas can handle entire column
> references. Rather than using D:D, use something like
> D1:D2000.
>
> HTH
> Jason
> Atlanta, GA
>
> >-----Original Message-----
> >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:D=A4),--
> ('Turnover Details
> >by HR Group'!B:B=$B$2))
> >
> >Please help. Thank you,
> >Mike
> >.
> >
>