Count cells
 

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

Count cells
 

On May 28, 1:21*pm, Question Boy
wrote:
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.

Count cells
 

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

Count cells
 

=SUMPRODUCT(--(A2:A200=1),--(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

Count cells
 

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

Count cells
 

Thank you all so very much!




"Bob Phillips" wrote:

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