For OP

If the sheets are named Week1 through Week52 a list can easily be made on a
separate worksheet.

Type Week1 in A1

Right-click A1 and drag down to A52.

Release button and "Fill Series".

Name that range as MySheets as Peo suggests.

If not named as such you can use a macro to get a list of sheetnames on a
new sheet named "List"

Private Sub ListSheets()
'list of sheet names starting at A1
Dim rng As Range
Dim i As Integer
Worksheets.Add(After:=Worksheets(Worksheets.Count) ).Name = "List"
Set rng = Range("A1")
For Each Sheet In ActiveWorkbook.Sheets
If Sheet.Name < "List" Then
rng.Offset(i, 0).Value = Sheet.Name
i = i + 1
End If
Next Sheet
End Sub


Gord Dibben MS Excel MVP

On Wed, 11 Nov 2009 15:47:38 -0800, "Peo Sjoblom" wrote:

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(INDIREC T(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