Count occurences in array with condition

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
Back
Top