Finding min,max in an array using selected rows from a table

  • Thread starter Dazed and confused about min, max
  • Start date
D

Dazed and confused about min, max

I have a table which has time values in column B and numerical values in
column C. I am using the Sumproduct function with great success to calculate
the average value of C for all entries where the time is greater than 730am
and less than 930am. The problem is I need to find the minimum and maximum
values of C using this same criteria. I tried using Min(if( with no success
but I'm not sure if that is a correct use of the Min function. Can someone
please help?
 
P

Peo Sjoblom

=MAX(IF((time>=time1)*(time<=time2),values))

entered with ctrl + shift & enter


--

Regards,

Peo Sjoblom


<Dazed and confused about min>; "max"
 

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
Max/Min per item from a changing list 0
Calculating Average, Count, Min & Max against a range of Values 0
array formulas using MIN MAX 3
Min excluding zero values, without an array fomrula 12
Conditional Formating: MAX & MIN 3
Need help finding a substring in a array of strings. 1
Using Min Function within DLookup Function 0

Top