Hi Q,

Try something like:

=SUMPRODUCT(--(Sheet2!A1:A20=1),--(Sheet2!B1:B20=0))



---
Regards.
Norman
"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