Hi,

I was hoping some one could help.

I am working with 2 workbooks. The one has 31 worksheets (one for each
day of the month) the other uses the inputs from each day and
calculates what should be left. Its fairly simple (adding the values
of the two cells and subtracting a third cell)

The formula works for the first three days however it evalutes to
#value there after. I cant understand why the identical formula
suddenly causes an error.

Could anyone please offer suggestions as to what can be causing this
error.

Thanks in advance
Ullie

N.B: this same thing has happend with two different formulas.
e.g1:
=E163-(E58+E8)..... this works however after that it doesnt one doesnt
i.e. =F163-(F58+F8)
e.g2:
='MSA 04.06.06'!B16:C16-'[Test.xls]June Daily Sales-Units'!$F$58....
this works but the next one doest and it also returns #value if i want
to add another cell to it. i.e: stock ordered