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

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

Hi Q,

Try something like:

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



---
Regards.
Norman
"Question Boy" <(E-Mail Removed)> wrote in message
newsD5CC200-AA90-4491-A7CC-(E-Mail Removed)...
>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

=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" <(E-Mail Removed)> wrote in message
newsD5CC200-AA90-4491-A7CC-(E-Mail Removed)...
>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

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" <(E-Mail Removed)> wrote in message
newsD5CC200-AA90-4491-A7CC-(E-Mail Removed)...
>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

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" <(E-Mail Removed)> wrote in message
> newsD5CC200-AA90-4491-A7CC-(E-Mail Removed)...
> >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
>
>
>