Results 1 to 3 of 3
  1. #1
    Lounger
    Join Date
    Aug 2002
    Location
    MN, USA
    Posts
    49
    Thanks
    0
    Thanked 0 Times in 0 Posts

    SUM issues (2002)

    Take a look at the attached file. At the bottom of sheet1 (row 157) there is a sum. For some reason it isn't working correctly. The format seems fine and it was working fine last week. The only thing that changed was the sheet reference. We find-replaced the formulas to change them to look at the week1 sheet. There aren't any problems pulling the data from the sheet, so why are there summing issues?

  2. #2
    5 Star Lounger
    Join Date
    Oct 2001
    Location
    San Bernardino, California, USA
    Posts
    734
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: SUM issues (2002)

    It seems that the information on the week1 sheet are not numeric - hence unable to be mathematically manipulated. Try the attached spreadsheet - I presume the data on week1 is imported in a text format (although not intentionally). Given this, and the fact that it may be beyond your control, I used the value function in your formula.

  3. #3
    Lounger
    Join Date
    Aug 2002
    Location
    MN, USA
    Posts
    49
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: SUM issues (2002)

    Yup that's it, thanks. Forgot to do that this week.

Posting Permissions

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