For the MIN:

Array entered** :

=MIN(IF(CJ5:CJ650,CJ5:CJ65))

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER). Hold down both the CTRL key and the SHIFT
key then hit ENTER.

For the MAX:

=MAX(CJ5:CJ65)

--
Biff
Microsoft Excel MVP


"Mike" wrote in message
...
Im trying to put a formula in CL4 for min hours for CJ5:CJ65 & if <=0 have
zero value
ALSO in CM4 FOR max HOURS for CJ5:CJ65