SMALL function
Looking at the way your formula is constructed it appears that you want the
min that is greater than 0 so I guess that means then are no negative
numbers.
Try this array formula** :
=MIN(IF((MOD(COLUMN(E51:AL51),3)=2)*(E51:AL510),E 51:AL51))
** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER)
--
Biff
Microsoft Excel MVP
"Wally3178" wrote in message
...
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
|