Jim,
MAX and MIN work OK if you simply assign a range of data e.g
=MAX(a3:a32) but as you have found doesn't appear work with an array formula.
Perhaps a post to one of the gurus (Tom Ogilvy, Bob Philips et al) may get an
answer: no offence to Murray intended.

Just a thought: how are you handling leap years?

"postman Jim" wrote:


Thanks for tyhe help. I have noticed that if a whole month is negative
the MAX array comes up with Zero. If I change the array to MIN, it only
works for the below Zero temps. From Mar thru Nov it comes up with Zeros
for the minimum temp. It this a flaw in Excel?


*** Sent via Developersdex http://www.developersdex.com ***