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?