Hi,

I am trying to display the minimum temperature for the year by using the
following formula:

=SMALL(E51,H51,K51,N51,Q51,T51,W51,Z51,AC51,AF51,A I51,AL51,COUNTIF($E51,$H$51,$K$51,$N$51,$Q$51,$T$5 1,$W$51,$Z$51,$AC$51,$AF$51,$AI$51,$AL$51,0)+1)

Can anyone tell me why this formula won't work?

The cells are each months minimum temperature which is calculated using the
MIN function

Cheers,
--
Wal