Minimum in date range

[doubledaffy]

I'm looking to find the minimum temperature in a specified date range. I have two named ranges "Fulldate" which gives the date and "Temp" which gives the corresponding temperature.

I tried finding the minimum using ={MIN(Temp*(Fulldate>=X)*(Fulldate<=Y))}

Where X and Y are the starting and end dates that I specify. However, this doesn't work. The minimum ends up being the zeroes for the dates that don't meet the X and Y criteria.

Any idea how I can changes this and get it to work?

Thanks.

 

[Andrew Poulsom]

You can't do it with multiplication. Try:

=MIN(IF(Fulldate>=X,IF(Fulldate<=Y,Temp)))

confirmed with Ctrl+Shift+Enter.

 

[doubledaffy]

Thanks! Works perfectly.