Dependent on the error, you might also have an if statement reference to a
sell that is blank, but without a qualifier of what to do if the cell is
blank.

God Bless

Frank Pytel

"Abacus28" wrote:

I have a converted 2007 excel file that I am working in Excel 2003. There
are 31 worksheets that are for each day of a month and a summary worksheet
that simply totals the cells across the worksheets.

I am getting a "Value" error on the summary worksheet and the fornulas
appear fine. I found however, that if I put a zero in each of the cells that
are current blank (because there was no activity for that item on that
particular day) then the error goes away and I get the total.

Does anyone know what could be causing the problem - I have tried
reformating all of the cells to a numeric setting and it does not help?