Carl,

=SUM((Sheet2!$A$2:$A$20000=Sheet1!$E3)*(Sheet2!$J$ 2:$J$20000=Sheet1!$D$3))

HTH,
Bernie
MS Excel MVP


"carl" wrote in message
...
I use the following array formula. I wanted to adapt it to count (vs sum).
Is
it possible ??


=SUM(IF((Sheet2!$A$2:$A$20000=Sheet1!$E3)*(Sheet2! $J$2:$J$20000=Sheet1!$D$3)
;Sheet2!$I$2:$I$20000))

Thank you in advance.