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

Hi Bob,

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

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" wrote in message
...
I read it as

=SUMPRODUCT(--(D5:D1930),--(I5:I1930))

--
HTH

Bob Phillips

"KL" wrote in message
...
Try:

=SUMPRODUCT(--((D5:D1930)+(I5:I1930)0))

Regards,
KL


"Zuki" wrote in message
...
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)

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

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" wrote in message
...
Hi Bob,

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

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" wrote in message
...
I read it as

=SUMPRODUCT(--(D5:D1930),--(I5:I1930))

--
HTH

Bob Phillips

"KL" wrote in message
...
Try:

=SUMPRODUCT(--((D5:D1930)+(I5:I1930)0))

Regards,
KL


"Zuki" wrote in message
...
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)