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
.