min thats = 0
The formula needs to be entered with ctrl + shift & enter
--
Regards,
Peo Sjoblom
"Peo Sjoblom" wrote in message
...
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
|