J

#### johnsmyth67

The following array formula works perfectly.

{=MAX(($G$3:$G$11939>=$S3)*($G$3:$G$11939<$S4)*(J$3:J$11939))}

However, when I attempt to use the formula shown below, substituting

MIN for MAX, it returns only zeros.

{=MIN(($G$3:$G$11939>=$S3)*($G$3:$G$11939<$S4)*(J$3:J$11939))}

Please note the following...

1. I have confirmed the formula is entered as an array.

2. There are no zeros or negative values in the array.

3. There are no text entries in the array; only positive values.

4. The formulas are supposed to determine the maximum and minimum

values in column J

based on conditions defined in the cells S3 and S4 relative to column

G.

Any help would be most appreciated, as always.

Cheers,

Joseph