The best way would be if you change the data so that W265 has a blank
instead of zero before anything is entered.


Otherwise you might be able to use something like


=MIN(IF(N(INDIRECT(MySheets&"!W265"))0,N(INDIRECT (MySheets&"!W265"))))

where MySheets is a named range containing the names of all the sheets you
are using so for a year that would be a list of 52 sheets

--


Regards,


Peo Sjoblom


"Mike" wrote in message
...
I Have 52 work sheets each sheet = one week, on each sheet cell W265 IS
ZERO
& on a seperate work sheet im trying to figure out min I tried alot of
different formulas for example =min('week 1:week 52'!,w265) the cell im
using
will read zero until data is entered & still reads zero so i tried 0 in
formula & get a ref error can some one please help with this