Count cells

[Question Boy]

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

 

[JW]

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

Assuming that your Type is in column A and your Delta is in column B

=SUM((A2:A9=1)*(B2:B9=0))

This is an Array formula and must be entered with Ctrl+Shift+Enter.

 

[Norman Jones]

Hi Q,

Try something like:

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

 

[Bob Phillips]

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

--
---
HTH

Bob


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

 

[Bob Phillips]

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]

Thank you all so very much!

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)