Count occurences in array with condition

[Guest]

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.

 

[Domenic]

Try...

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

Hope this helps!

 

[Guest]

Thanks, Domenic. It did work.

Try...

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

Hope this helps!