Excel 97
Results 1 to 2 of 2

Thread: Excel 97

  1. February 28th, 2002, 10:10 AM #1
    lajohn63
    lajohn63 is offline Virtual Med Student
    Join Date
    Feb 2002
    Location
    Richmond, VA
    Posts
    1

    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
    Reply With Quote Reply With Quote
  2. February 28th, 2002, 09:47 PM #2
    Dreamboat's Avatar
    Dreamboat
    Dreamboat is offline Author: Dreamboat on Word
    Join Date
    Oct 1998
    Posts
    473
    What's the formula, Lisa?

    ------------------
    TheWordExpert
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules