This does not work i tried, In cel CJ5:CJ65 i have a formula in there & it
works but i get #NA just until other data,s are entred =INDIRECT("e" &
VLOOKUP(ROW()-4,CP$5:CR$65,3,FALSE)) COULD THIS BE WHY because i get same for
the formulas that you gave me but does not work when other data,s are entered

"T. Valko" wrote:

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


.