Excel 97

Working with multi-worksheet file. I have a formula which adds up various cells and pulls them back to another worksheet. I capture data monthly but have built the worksheet for the entire year, so its a plug in situation. The problem I have is that the fields for months farther out are blank and when added together give the error #value. How can I get it to bring back blanks? These fields are numeric & currency

------------------
LisaJ