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

[Guest]

count number of matching cells in to colums where their value are greater
than 0. i.e. D5193 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)

 

[KL]

Try:

=SUMPRODUCT(--((D5193>0)+(I5:I193>0)>0))

Regards,
KL

 

[Bob Phillips]

I read it as

=SUMPRODUCT(--(D5193>0),--(I5:I193>0))

 

[KL]

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]

Hi KL,

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