Count occurences in array with condition
 

Experts! See if you can help

Column I, range I200:I800
Column J, range J200:J800

I'm trying to count the number of occurences when number in column J is less
than number in column I (Values in column J are either less or equal to
values in column I) in the array. Counting when J and I are simply not equal
would work for me too. I cannot add any columns. I'm looking for solution
without using another sheet.

Any suggestion is appreciated.

Count occurences in array with condition
 

Try...

=SUMPRODUCT(--(J200:J800<""),--(J200:J800<I200:I800))

Hope this helps!

In article ,
Val wrote:

Experts! See if you can help

Column I, range I200:I800
Column J, range J200:J800

I'm trying to count the number of occurences when number in column J is less
than number in column I (Values in column J are either less or equal to
values in column I) in the array. Counting when J and I are simply not equal
would work for me too. I cannot add any columns. I'm looking for solution
without using another sheet.

Any suggestion is appreciated.

Count occurences in array with condition
 

Thanks, Domenic. It did work.

"Domenic" wrote:

Try...

=SUMPRODUCT(--(J200:J800<""),--(J200:J800<I200:I800))

Hope this helps!

In article ,
Val wrote:

Experts! See if you can help

Column I, range I200:I800
Column J, range J200:J800

I'm trying to count the number of occurences when number in column J is less
than number in column I (Values in column J are either less or equal to
values in column I) in the array. Counting when J and I are simply not equal
would work for me too. I cannot add any columns. I'm looking for solution
without using another sheet.

Any suggestion is appreciated.