Should have been

=SUMPRODUCT(--(Sheet2!A2:A200=1),--(Sheet2!B2:B200=0))

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Question Boy" wrote in message
...
I have 2 sheets.

Sheet 2, which has a data table and Sheet 1, which is to tabulate the
data.

Sheet 2 has 2 columns, Type and Delta.

How can I count the number of entry in Sheet 2 that are of Type =1 and
whose
Delta = 0?

Thank you,

QB