Finding minimum value across selected rows of an array

I have a table of data which has time values in column B and numerical values
in column C. I am using the Sumproduct function to find the average value of
C using only data when the time is between 730 and 930 with great success.
The problem is I also need to find the minimum and maximum values during
these same times.

I tried using Max(if( with ctrl-shft-enter (though I'm not sure if this is a
proper formula) with no luck. Can someone please help?

Biff anwered when I asked

I was getting the mode, min, max in D if conditions in a,
b, & c are met. these work for me:

All are array formulas, enter with the key combo of
CTRL,SHIFT,ENTER:

=MODE(IF(A1:A10="x",IF(B1:B10="y",IF(C1:C10="z",D1:D10))))

=MIN(IF(A1:A10="x",IF(B1:B10="y",IF(C1:C10="z",D1:D10))))

=MAX(IF(A1:A10="x",IF(B1:B10="y",IF(C1:C10="z",D1:D10))))

Biff


>-----Original Message-----
>I have a table of data which has time values in column B
and numerical values
>in column C. I am using the Sumproduct function to find
the average value of
>C using only data when the time is between 730 and 930
with great success.
>The problem is I also need to find the minimum and
maximum values during
>these same times.
>
>I tried using Max(if( with ctrl-shft-enter (though I'm
not sure if this is a
>proper formula) with no luck. Can someone please help?
>.
>

This worked like a charm. Thank you very much BobT.

"BobT" wrote:

> Biff anwered when I asked
>
> I was getting the mode, min, max in D if conditions in a,
> b, & c are met. these work for me:
>
> All are array formulas, enter with the key combo of
> CTRL,SHIFT,ENTER:
>
> =MODE(IF(A1:A10="x",IF(B1:B10="y",IF(C1:C10="z",D1:D10))))
>
> =MIN(IF(A1:A10="x",IF(B1:B10="y",IF(C1:C10="z",D1:D10))))
>
> =MAX(IF(A1:A10="x",IF(B1:B10="y",IF(C1:C10="z",D1:D10))))
>
> Biff
>
>
> >-----Original Message-----
> >I have a table of data which has time values in column B
> and numerical values
> >in column C. I am using the Sumproduct function to find
> the average value of
> >C using only data when the time is between 730 and 930
> with great success.
> >The problem is I also need to find the minimum and
> maximum values during
> >these same times.
> >
> >I tried using Max(if( with ctrl-shft-enter (though I'm
> not sure if this is a
> >proper formula) with no luck. Can someone please help?
> >.
> >
>