| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do you count data that matches more than one condition? | Excel Worksheet Functions | |||
| How do I count occurences in a date range? | Excel Worksheet Functions | |||
| how to count unique entries with multiple condition | Excel Worksheet Functions | |||
| How can you use count with an array formula similar to using sum | Excel Worksheet Functions | |||
| Formula to count number of dates in an array | Excel Worksheet Functions | |||
Hybrid Mode
