lajohn63
February 28th, 2002, 09:10 AM
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
------------------
LisaJ