how do I use COUNTIF in excel. using criteria from multiple colums

count number of matching cells in to colums where their value are greater
than 0. i.e. D5:D193 and I5:I192 - all corresponding cells from the two
ranges that have value of more than zero to be counted as one occurrance. (D8
value 2 and I8 value 4, to be counted as one)

Try:

=SUMPRODUCT(--((D5:D193>0)+(I5:I193>0)>0))

Regards,
KL


"Zuki" <[email protected]> wrote in message
news:[email protected]...
> count number of matching cells in to colums where their value are greater
> than 0. i.e. D5:D193 and I5:I192 - all corresponding cells from the two
> ranges that have value of more than zero to be counted as one occurrance.
> (D8
> value 2 and I8 value 4, to be counted as one)

I read it as

=SUMPRODUCT(--(D5:D193>0),--(I5:I193>0))

--
HTH

Bob Phillips

"KL" <[email protected]> wrote in message
news:[email protected]...
> Try:
>
> =SUMPRODUCT(--((D5:D193>0)+(I5:I193>0)>0))
>
> Regards,
> KL
>
>
> "Zuki" <[email protected]> wrote in message
> news:[email protected]...
> > count number of matching cells in to colums where their value are
greater
> > than 0. i.e. D5:D193 and I5:I192 - all corresponding cells from the two
> > ranges that have value of more than zero to be counted as one
occurrance.
> > (D8
> > value 2 and I8 value 4, to be counted as one)
>
>

Hi Bob,

I have re-read the original post and I am still not sure if Teresa wants to
count the rows where:

1) at least one of the cells D# and I# are greater than 0
or
2) both cells D# and I# are greater than 0 at the same time

....but it may be my English :-)

Regards,
KL


"Bob Phillips" <[email protected]> wrote in message
news:[email protected]...
>I read it as
>
> =SUMPRODUCT(--(D5:D193>0),--(I5:I193>0))
>
> --
> HTH
>
> Bob Phillips
>
> "KL" <[email protected]> wrote in message
> news:[email protected]...
>> Try:
>>
>> =SUMPRODUCT(--((D5:D193>0)+(I5:I193>0)>0))
>>
>> Regards,
>> KL
>>
>>
>> "Zuki" <[email protected]> wrote in message
>> news:[email protected]...
>> > count number of matching cells in to colums where their value are
> greater
>> > than 0. i.e. D5:D193 and I5:I192 - all corresponding cells from the two
>> > ranges that have value of more than zero to be counted as one
> occurrance.
>> > (D8
>> > value 2 and I8 value 4, to be counted as one)
>>
>>
>
>

Hi KL,

I could see where your thinking came from , it wasn't clear, and that is not
just your English :-).

--
HTH

Bob Phillips

"KL" <[email protected]> wrote in message
news:Ok6g%[email protected]...
> Hi Bob,
>
> I have re-read the original post and I am still not sure if Teresa wants
to
> count the rows where:
>
> 1) at least one of the cells D# and I# are greater than 0
> or
> 2) both cells D# and I# are greater than 0 at the same time
>
> ...but it may be my English :-)
>
> Regards,
> KL
>
>
> "Bob Phillips" <[email protected]> wrote in message
> news:[email protected]...
> >I read it as
> >
> > =SUMPRODUCT(--(D5:D193>0),--(I5:I193>0))
> >
> > --
> > HTH
> >
> > Bob Phillips
> >
> > "KL" <[email protected]> wrote in message
> > news:[email protected]...
> >> Try:
> >>
> >> =SUMPRODUCT(--((D5:D193>0)+(I5:I193>0)>0))
> >>
> >> Regards,
> >> KL
> >>
> >>
> >> "Zuki" <[email protected]> wrote in message
> >> news:[email protected]...
> >> > count number of matching cells in to colums where their value are
> > greater
> >> > than 0. i.e. D5:D193 and I5:I192 - all corresponding cells from the
two
> >> > ranges that have value of more than zero to be counted as one
> > occurrance.
> >> > (D8
> >> > value 2 and I8 value 4, to be counted as one)
> >>
> >>
> >
> >
>
>