Finding minimum value across selected rows of an array

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

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trying to find additional ranges outside of min, max, and average 2
Finding min,max in an array using selected rows from a table 1
Need to get minimum difference 1
minimum value in a column, which row no? 6
Minimum results 4
Calculating a Formula Subject to a Maximum and Minimum Value 2
Minimum array formula. 5
Return the minimum number in a range excluding zero 3

Back
Top